holding down shift key to prevent workbook_open code

[conception_native_0123]

if i open excel blank and no workbook, i able to open another book in that instance holding down shift and the code on open event does not run. is this true for all office programs? thank you. is there any other to do?

 

[isladogs]

The shift bypass stops code running in Access as well. As all Office programs use VBA, I expect its also true for the rest of the Office programs

 

[conception_native_0123]

thank you

 

[Isaac]

No, shift bypass is not available to bypass Excel workbook open code. If you are experiencing something that looks like it's working, it's probably because that particular workbook is opening, at that particular time, with macros disabled.

At least on Office 365, I just tried holding down Shift while opening a workbook, and it did not bypass workbook_open code - the code still ran.
And it has never worked for me before in 20 years of using workbook open code.

One thing you can do is disable macros, then open the workbook with the code.

 

[isladogs]

According to this article Disable Shift key on open • Pixcels.nl, the Shift bypass key DOES disable to Workbook_Open event.
However, it is possible to over-ride this behaviour by customising the ribbon. If so, pressing the shift key has no effect

 

[Isaac]

Did a little bit more testing to try to discover the discrepancy.

Just tested it 5 times in a row on my xlsb, which has a Msgbox in the Workbook Open event. Shift bypass doesn't work.

However, I tested it on an xlsm file, and it caused the enable/disable macros window to be shown, and even when I press enable, the Msgbox is not shown - so apparently the code is being bypassed.

My conclusion from testing, then, is that it works on XLSM, but not XLSB. It makes sense, then, that it works for "some" but has not worked in years for me....I never use xlsm for Excel development.

Thanks @isladogs, I learned something new - one more reason to add to my list why to use XLSB only.

 

[isladogs]

Whilst I understand the benefits of XLSB such as smaller file size, I've very rarely used them.
One potential disadvantage of XLSB is that Power Query AKA Get & Transform is apparently unable to read data from XLSB files
See XLSX or XLSB: Why to save a workbook in binary format (spreadsheet1.com)