Unknown Macro

leftyb

New Member
Joined
Jan 19, 2005
Messages
5
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

martinee

Well-known Member
Joined
Nov 4, 2003
Messages
960
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

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
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
 

leftyb

New Member
Joined
Jan 19, 2005
Messages
5
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
 

Forum statistics

Threads
1,147,621
Messages
5,742,180
Members
423,709
Latest member
AMacL

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top