View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed[_2_] Vacuum Sealed[_2_] is offline
external usenet poster
 
Posts: 87
Default Save without Macros without prompting

Hi Travis

Chip Pearson has a great code for removing VB Projects / Modules, you name
it...

I use it at work and it works very well.....

http://www.cpearson.com/Excel/vbe.aspx

Just remember to make sure this has a tick:

Macro Security | Trust access to the VBA Project Object Model.

Else the code will not not work....

HTH
Mick