Is there an attribute assigned to a spreadsheet that identifies that a Macro was created and can this be reset?
With the Macro security set at medium, if a Macro was ever created for a spreadsheet, you are prompted whether or not to Enable or Disable MACROS. If a MACRO was never created in the spreadsheet, you are not prompted at Medium security. If you delete all the MACROS from the spreadsheet and save the file. When you re-open it at Medium security, you are still prompted reagrding enabling MACROS. Is there a way to delete that attribute from a spreadsheet (where all MACROS have been deleted), so as not to be prompted (besides changing security to High)
Software/Hardware used:
Software/Hardware used:
ASKED:
June 10, 2009 8:00 PM
UPDATED:
June 11, 2009 10:05 PM
Answer Wiki:
Excel still prompts you because there are still some modules associated with the spreadsheet. Do the following steps to remove the modules.
1. Open the Visual Basic editor in your spreadsheet using ALT-F11.
2. Press CTRL-R for the project explorer.
3. Expand the Modules folder
4. Right click on each module and click on remove
5. Save your spreadsheet
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
