How to suspend Workbook_Open code from running when opening file?

[cptk]

Is there a way to suspend the "Workbook_Open" code from running when opening a file?. e.g.- like hold the ctrl down or some other key combinations?

 

[SkipVought]

Hi,

Disable macros.

Skip,

_[red][/red]

 

[PHV]

Hold the Shift key down.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cptk]

Yes, that's what I end of doing (to just get into the file without the code automatically executing).

But the side effects of doing so puts the file in "edit mode", which then doesn't allow you to run macros at all - even when you try to set security to "Low".

 

[cptk]

Shift key ... that's it ... I don't know why I was fixated only the ctrl key ... thanks PHV (it seems you helped me in the past on unix-type issues ... thanks again!!!)