ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macros in Excel Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/98951-macros-excel-worksheet.html)

dknorwood

Macros in Excel Worksheet
 
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

Macros in Excel Worksheet
 
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

On Wed, 12 Jul 2006 16:19:02 -0700, dknorwood
wrote:

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?



bpeltzer

Macros in Excel Worksheet
 
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...".

"dknorwood" wrote:

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?


dknorwood

Macros in Excel Worksheet
 
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

"Gord Dibben" wrote:

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

On Wed, 12 Jul 2006 16:19:02 -0700, dknorwood
wrote:

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?




dknorwood

Macros in Excel Worksheet
 
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

"bpeltzer" wrote:

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

"dknorwood" wrote:

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

Macros in Excel Worksheet
 
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


On Wed, 12 Jul 2006 16:51:01 -0700, dknorwood
wrote:

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

"bpeltzer" wrote:

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

"dknorwood" wrote:

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?



dknorwood

Macros in Excel Worksheet
 
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" wrote:

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


On Wed, 12 Jul 2006 16:51:01 -0700, dknorwood
wrote:

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

"bpeltzer" wrote:

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

"dknorwood" wrote:

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

Macros in Excel Worksheet
 
Good to hear you're sorted out.

Thanks for the feedback.


Gord

On Wed, 12 Jul 2006 17:21:02 -0700, dknorwood
wrote:

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" wrote:

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


On Wed, 12 Jul 2006 16:51:01 -0700, dknorwood
wrote:

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

"bpeltzer" wrote:

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

"dknorwood" wrote:

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 MS Excel MVP


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com