View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default removing a macro from a workbook

Hi Roger

You need to also delete any/all standard modules that you have in the
workbook (whether or not they actually conatin any code) to make sure
you don't get that annoying macro warning (I assume you've cleared the
Thisworkbook/Sheets modules).

Hope this helps!

Richard



Roger wrote:
I have a workbook that I used a few macros on, and possible created one in
(but deleted) and now whenever anyone opens it they get the enable/disable
macro warning. I've looked in all places that I know to find a macro to
delete, but there is nothing. How to I clear what ever is prompting the
warning

thanks in advance