ExcelBanter - Workbook open event

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Workbook open event (https://www.excelbanter.com/excel-programming/363926-workbook-open-event.html)

Workbook open event

I have some statements in the Workbook open event.
How can I open the Workbook without running these statements ?
Have I to press a specific key during opening the Workbook ?

Ron de Bruin

Workbook open event

Hi Hans

Hold the Shift key when you open the workbook in Excel
Note: this is not working if you open the file by double clicking on it in a folder

--
Regards Ron De Bruin
http://www.rondebruin.nl

wrote in message ...

I have some statements in the Workbook open event.
How can I open the Workbook without running these statements ?
Have I to press a specific key during opening the Workbook ?

All times are GMT +1. The time now is 07:32 PM.