Macro warning box

  • Thread starter Thread starter Quaisne
  • Start date Start date
Q

Quaisne

Okay this is my first post so be gentle.

Could someone tell me how I can get rid of the macro warning box from
single worksheet.

Someone sent me a spreadsheet to comment on but it contained macros
The macros were used for navigation purposes so I deleted them
Unfortunately I cannot get rid of the warning box thjt pops up ever
time I open the workbook asking if I want to enable macros or not eve
though the worksheet no longer contains macros.

I do not want to change the macro security level as I want to be warne
about macros on other worksheets. I just want to get rid of the warnin
on this one workbook.

Can someone tell me how? :confused
 
Quaisne, You also have to remove the modules on which the macros were stored
have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
That is suberb that pesky box has now been delt with. It is funny how
things can be so frustrating to deal with when you don't know how.
 
Back
Top