Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot use Data Analysis tools on Excel worksheet embedded in PwrP | Excel Worksheet Functions | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel |