View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Macro statement when opening file, but no macro

Hi Robert,

'-----------------
Thanks Norman. Worked like a charm ... save for having to scroll through
40-60 worksheets in 4 different workbooks. Lots of work, but it worked.
'-----------------

I am glad that you have resolved your problem.

However, had the extent of your problem been apparent,
I would have referred you to Chip Pearson at:

Deleting All VBA Code In A Project
http://www.cpearson.com/excel/vbe.htm#DeleteAllVBA

and I would have suggested code to loop through the
required workbooks.


---
Regards,
Norman