View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default 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?