Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Anne
 
Posts: n/a
Default After deleting a macro, I still get the pop-up when opening file

After deleting a macro, I still get the pop-up when opening my excel file
that asks if I want to enable or disable macros. How do I get rid of the
pop-up? There are no longer any macros in the spreadsheet.
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Anne,

That could be because the module that the macro was in is still there. Goto
the VBE, and with that project, check if there are any modules. If so, right
click it in the explorer window, and choose Remove (don't export it).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anne" wrote in message
...
After deleting a macro, I still get the pop-up when opening my excel file
that asks if I want to enable or disable macros. How do I get rid of the
pop-up? There are no longer any macros in the spreadsheet.



  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.contextures.com/xlfaqMac.html#NoMacros

--
Regards
Frank Kabel
Frankfurt, Germany

"Anne" schrieb im Newsbeitrag
...
After deleting a macro, I still get the pop-up when opening my excel

file
that asks if I want to enable or disable macros. How do I get rid of

the
pop-up? There are no longer any macros in the spreadsheet.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening CSV file in Excel 97 Ron P Excel Discussion (Misc queries) 4 January 14th 05 10:41 PM
How do I force an Excel macro to ask me which file and directory? Ramius Excel Discussion (Misc queries) 4 January 14th 05 03:26 PM
restrict opening Excel file residing on a shared drive to one user k-ham Excel Discussion (Misc queries) 1 January 7th 05 01:57 AM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 03:39 PM
Macro did not run after download file from net ariffin Excel Worksheet Functions 2 November 6th 04 01:20 AM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"