This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 84%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
I need to run a macro on excel opening to find the username to display only required data. This wont work if the file is opened in a browser.
a. Is there anyway of completely stopping a file from being opened in a browser?
b. If not, is there anyway of finding a username from someone opening an excel file in a browser and stopping data being displayed until this can be used?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Hi @Adam Baker
Thanks so much for reaching out to the Microsoft Q&A Forum.
I understand you’re using a macro to check the username when the file opens and display only the required data, but that approach isn’t working when the file is opened in a browser.
Unfortunately, Excel Online doesn’t support VBA, so there’s currently no built-in way to detect the username or run any macros when the file is opened in the browser. Macros only work when the file is opened in the desktop version of Excel, so any logic based on user identity would need to happen there.
Based on what I’ve researched, there’s a setting you can try if your Excel file is stored in a SharePoint Online document library, it may help encourage the file to open in the desktop app:
In addition, I also tried changing the setting in Excel itself by going to:
I gave it a try myself, but unfortunately it hasn’t worked just yet, it’s possible the change needs a bit of time to take effect. I’ll monitor it and keep you posted if anything changes.
Feel free to give it a try on your end and let me know how it goes.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Adam Baker
Have you been able to take a look at the suggestions shared earlier?
If you’ve had a chance to try them out, I’d be happy to hear how things went.
I'm looking forward to hearing from you soon.
Thanks for your help - I have implemented these processes which help but setting a preference to open in the desktop App is not the same as preventing someone opening the file in the browser which I need, as I would like to use VBA to only show required data depending on who the user is.
if you have any ideas on how to stop that happening, that would be great