View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Workbook_Open operates correctly in single step but not when run

Post the code.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Deagles" wrote in message
...
At workbook open my VB process checks 4 worksheets within the workbook for
row which should be deleted. The code works perfectly but is slow, so I
added first a StatusBar message showing progress, but as this did not work
I
substituted a MsgBox statement at beginning and end. These MsgBox texts
do
not operate either, whereas the original MsgBox delete messages continue
to
work perfectly. To add to my puzzlement, the added code works perfectly
when
I use single step.

Advice will be very gratefully received

Deagles