View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Document contains macros message

Press Alt + F11 to open the Visual Basic Editor and if the Project Viewer is
not visible on the left side of the screen, press <Ctrl + R. In the project
tree, if the VBAProject (YourWorkbookName) has a + sign to its left,click to
expand the view.

Click the + sign to the left of the Microsoft Excel Objects folder to
display all worksheet and the workbook icon, and if there's a Module folder,
click its + sign to view all modules.

To delete the module, right click and select REMOVE MODULE, save it if you
want to to a location on your PC. Then double click on each worksheet icon
and if there's any code displayed, select it and press the DELETE key. Then
double click the workbook icon and select any code that might be there and
press DELETE. Click FILE in the menu and select CLOSE AND RETURN TO EXCEL.

Save and close the workbook and when you reopen it there should not be a
macro warning message.

Hope this helps



--
Kevin Backmann


"april" wrote:

Hi

I am receiving the warning that my document contains macros. This was
because at one time I had created a macro for the document. I no longer use
the macro.

How do I delete the macros (I cannot find the with the spreadsheet) as I do
not want to receive the warning anymore.

Thank you
Regards.