Visual Basic closes excel when it is opened

[claver]

When I open an excel spreadsheet, VB runs and then immediately closes the spreadsheet. I would like to edit the VB in the spreadsheet, but cannot keep it open to do so. Any suggestions?

This was created in an *.xls 97 - 2003 worksheet

 

[RoryA]

Welcome to the forum.

Hold down the shift key while opening the workbook.

 

[Oaktree]

Welcome to the board.

Sounds like there is a workbook_open event that includes code to close the workbook.

Try holding down SHIFT while you click "open" from within Excel (as opposed to using my computer, explorer, etc. to find it and opening it from within one of those).

SHIFT + open will bypass the workbook_open event.

 

[claver]

Welcome to the board.

Sounds like there is a workbook_open event that includes code to close the workbook.

Try holding down SHIFT while you click "open" from within Excel (as opposed to using my computer, explorer, etc. to find it and opening it from within one of those).

SHIFT + open will bypass the workbook_open event.

Great thanks for the responses - worked!