Open program with Application.Quit?

[Milos Setek]

Hello all,

This is probably a dumb question but here it is.
If you have a program that starts up as soon it is clicked using sub
workbook_open() and if in the same program at the end you have application
..quit how do you open this program in the editor without using Ctrl
ScrollLock. On fast machines if the program does not do much it's almost
impossible to do the Ctrl ScrollLock fast enough before the program
disappears.

Welcome any suggestions with thanks.
Milos.

 

[Chip Pearson]

Milos,

Hold down the SHIFT key when you open the file from within Excel.
This prevents the startup code from running.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)