Thread: CLOSE WB
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default CLOSE WB

No virus, just a macro that will clean-up numerous open workbooks that have
been used in creating a master wb and are no longer needed and do not need to
be saved. This saves the time of going into each and shutting them down.
And it is only used on my computer.

I saw code on "close all but active", but I need the active and "workbook
2" to remain open.

"NickH" wrote:

Ronbo,

Are you trying to write a macro virus???

That kind action from your code would be potentially harmful to
people's data and make you a very unpopular bunny.

NickH