Macros in Excel Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a couple of macros for a custom worksheet. I have since deleted
them. However, every time the worksheet is opened I still get the popup
asking if I want to enable/disable macros. There are none to enable/disable.
Ideas?
 
You must also remove the empty module(s) that housed the macros.

ALT + F11 to go to VBEditor.

Expand your workbook/project and remove Module1 and any others.

Right-click and "remove module"

Click "No" when asked to export.


Gord Dibben MS Excel MVP
 
Delete the module, not just the macros within the module. From any sheet,
alt+F11 to open the VB editor. Right-click on module1 in the project
explorer (probably visible on the top left; if not View > Project Explorer)
and select "Remove Module1...".
 
Did this, but still get the enable/disable message. The only thing in the VB
listing are the individual sheets and the Excel woorkbook reference.

Any other ideas?

dknorwood
 
Thanks. This helped, but doesn't seem to clear the problem. Still getting
the enable/disable popup. Any chance that I have managed to tie this into a
general worksheet setup?

dknorwood
 
You will have to check each worksheet for any stray code.

Expand "Microsoft Excel Objects" to see sheets and Thisworkbook

D-Click to open a sheet module. Select and clear anything you find.

Also check Thisworkbook module for stray code.

And if any Forms, remove them.

See Debra Dalglesih's site. Maybe something we've forgotten.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord
 
Great! That did the trick. I hadn't realized that there must be some linkage
with other copies of the worksheet. Fortunately, I only had a few test
worksheets that I was experimenting with.

Thanks again!

dknorwood
 
Good to hear you're sorted out.

Thanks for the feedback.


Gord

Great! That did the trick. I hadn't realized that there must be some linkage
with other copies of the worksheet. Fortunately, I only had a few test
worksheets that I was experimenting with.

Thanks again!

dknorwood
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top