Macro warning box
 

Okay this is my first post so be gentle.

Could someone tell me how I can get rid of the macro warning box from a
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 every
time I open the workbook asking if I want to enable macros or not even
though the worksheet no longer contains macros.

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

Can someone tell me how? :confused:


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613

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

"Quaisne" wrote in
message ...

Okay this is my first post so be gentle.

Could someone tell me how I can get rid of the macro warning box from a
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 every
time I open the workbook asking if I want to enable macros or not even
though the worksheet no longer contains macros.

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

Can someone tell me how? :confused:


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613

That means there is some macro detritus left over. See
http://www.contextures.com/xlfaqMac.html#NoMacros for full instructions.

--
HTH

Bob Phillips

"Quaisne" wrote in
message ...

Okay this is my first post so be gentle.

Could someone tell me how I can get rid of the macro warning box from a
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 every
time I open the workbook asking if I want to enable macros or not even
though the worksheet no longer contains macros.

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

Can someone tell me how? :confused:


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613

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.


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613

Thanks that has worked fine


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=475613