View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JKP JKP is offline
external usenet poster
 
Posts: 2
Default How can I best "scrub" a wkbk of "phantom macros"?

Hi Dave

Can someone plz give me guidance as to how to get this workbook back to
its "virgin" state (i.e., plain ol' workbook that won't trigger macro
alerts)? Normally I wouldn't bother, but because I am dealing with
governments, well, the current behavior is a real drag.


I expect the fastest way is to do a save-as to 2007's xlsx file
format.
BTW: if you want the tool Dave referred to, send me an email. Address
is on the bottom of each page of my website.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com