Macros in Excel Worksheet

[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?

 

[Gord Dibben]

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

 

[Guest]

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...".

 

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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

 

[Gord Dibben]

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

Gord Dibben MS Excel MVP