Is there an attribute assigned to a spreadsheet that identifies that a Macro was created and can this be reset?

5 pts.
Tags:
Spreadsheet macros
Spreadsheets
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)
ASKED: June 10, 2009  8:00 PM
UPDATED: June 11, 2009  10:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following