View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Open program with Application.Quit?

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


"Milos Setek" wrote in message
...
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.