Unknown Macro

[leftyb]

I have a budget worksheet for 2004, with many rows and columns. (NO MACROS) No problem. As the new year began I saved the worksheet as 2005 and made several additions and deletions but did not create any Macros. Now when I open the worksheet I receive the MACROS warning.
A: I don't know why.
B: How can I delete the macro, if there is one.
C: I sure miss Lotus 123

leftyb

 

[martinee]

To delete macros, go to the VBE. (Hit Alt-F11)

Go to your Project Explorer for the workbook. (The smaller section on the left side of your screen. If it is not visible, then hit Ctrl-R)

Right-Click Any Modules Under your workbook, and choose "Remove Module1". You may be prompted to export the module first, but don't export, just delete.

Once all the modules are gone, save, close and re-open. Any better? HTH.

 

[Cbrine]

Leftyb,
You will also need to make sure you double click on each worksheets in the project explorer and highlight and delete any code that appears there as well as deleting the modules.

Cal

 

[martinee]

Thanks for that Cal, forgot all about those....hehe...

 

[leftyb]

Thank you Martinee and Cbrine. Maybe I have removed the problem but I am not sure. Each time I clicked on the worksheet in the VBA Project the pop-up shows GENERAL. Then I selected WORKSHEET and deleted whatever was there.
Apparently I needed to save the workbook after making the deletions in each worksheet. This took several trys but now when I open the Workbook NO MACRO WARNING appears.
I have never had faster responses than those in this forum. Thanks again.
leftyB