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

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