Question about workbook_Open macro

bknight
SilverLounger
Posts: 1679
Joined: 08 Jul 2016, 18:53

Question about workbook_Open macro

Post by bknight »

If a workbook is opened by a webpage instead of an application executable. Does the code contained in the Workbook_Open() still function/execute?

User avatar
HansV
Administrator
Posts: 80088
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Question about workbook_Open macro

Post by HansV »

No, VBA does not run in a browser.
Best wishes,
Hans

bknight
SilverLounger
Posts: 1679
Joined: 08 Jul 2016, 18:53

Re: Question about workbook_Open macro

Post by bknight »

That's bad. I have a very large workbook that I email, and I'm told it takes a long time to open in web browser and then scroll down to the active cell. Would you have an idea of how to allow those users to get to that area faster?

User avatar
HansV
Administrator
Posts: 80088
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Question about workbook_Open macro

Post by HansV »

If they have the desktop version of Excel, they could download the workbook from the email message, then open the downloaded copy in the desktop version.
Best wishes,
Hans