Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro security
Dear Office Users, I am using Excel 2003 (with SP2) and have my macro security setting sets to Medium. Everytime it detects a presence of macro, Excel will prompt me whether to Enable or Disable it. Originally I have a file with macro in it. After working for sometimes I decided to delete away the macro. However, when I open up that file Excel still prompts me whether to enable the macro or not while there isn't any macro anymore. Is this a known bugs or did I miss out something during the process? Regards, Mar -- marsulein ------------------------------------------------------------------------ marsulein's Profile: http://www.excelforum.com/member.php...o&userid=16064 View this thread: http://www.excelforum.com/showthread...hreadid=520895 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro security
Excel is seeing the module in which you deleted the macro. The presence of
the module is enough to trigger the macro query. Go into the VBE (where the macros reside.) Select the module. Click on File - Remove ModuleX. Click on No when prompted to export the module. Repeat this for every module that is there. Save the file. Close the file. Open the file and see if the query is still there. HTH Otto "marsulein" wrote in message ... Dear Office Users, I am using Excel 2003 (with SP2) and have my macro security setting sets to Medium. Everytime it detects a presence of macro, Excel will prompt me whether to Enable or Disable it. Originally I have a file with macro in it. After working for sometimes I decided to delete away the macro. However, when I open up that file Excel still prompts me whether to enable the macro or not while there isn't any macro anymore. Is this a known bugs or did I miss out something during the process? Regards, Mar -- marsulein ------------------------------------------------------------------------ marsulein's Profile: http://www.excelforum.com/member.php...o&userid=16064 View this thread: http://www.excelforum.com/showthread...hreadid=520895 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro Security | Excel Discussion (Misc queries) | |||
Disable macro security for selected workbook | Excel Discussion (Misc queries) | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) |