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

5 pts.
Tags:
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)
1

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: 2  Replies

 
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.
  • mallikasabari
    how will you assign a value to a variable in sap?

    10 pointsBadges:
    report
  • TheRealRaven
    @mallikasabari : There will be a much greater chance of getting answers if you create a question of your own. People looking at this thread are more likely to know about Excel and not know SAP.
    35,060 pointsBadges:
    report

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.

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

Following

Share this item with your network: