How to avoid macros getting disabled

  • Thread starter Thread starter deostroll
  • Start date Start date
D

deostroll

Hi,

When ever I write a piece of code and save & close my worksheet, and
then later open it again, I get a message box saying that macros in
the worksheet have been disabled. How do I get rid of this message box
and consequently avoid the problem of macros getting disabled...?

--deostroll
 
I would suggest you lower your security settings to medium or digitally sign the
project.


Gord Dibben MS Excel MVP
 
To add to Gord's response, you can get to security settings through
Tools/Macros/Security.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Notify user macros are disabled. 3
how to avoid user to save in .xlsx 2
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Disable Save 5
VBA Macros and Windows 7 1
How to force macros refer to ActiveWorkbook 2
Macros disabled, not by security settings? 5
Disable user interaction in VBA 1

Back
Top