Disabling Macros

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

I tried to change the security option for macros on a wkbk (with macros) to
try them out. I noted that if I set security to high, the wkbk opens and the
macro still runs. If I set it to medium, the dialog box asking if I want to
enable comes up. If I choose Enable or Disable the wkbk opens performing the
macro.
What is going on here?
Rob
 
Just an adendum to this. I searched the MSKB (235069 ), and tried their
solution as follows, but it doesn't work.
"To control this behavior, use the Trust all installed add-ins and templates
check box on the Trusted Sources tab of the Security dialog box. Clearing
this check box automatically disables macros in unsigned workbooks, even if
they are stored in any of the locations listed in the "Cause" section of
this article.
To clear the Trust all installed add-ins and templates check box, follow
these steps:
On the Tools menu, point to Macro and then click Security.
Click the Trusted Sources tab.
Click to clear the Trust all installed add-ins and templates check box and
then click OK.
NOTE: If you clear the Trust all installed add-ins and templates check box,
you will receive error messages when you start Excel if you are using any of
the add-ins that ship with Excel. For additional information about this
problem, click the article number below to view the article in the Microsoft
Knowledge Base: "

Rob
 
Back
Top