Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to enable Macro's

Status
Not open for further replies.

FeS2

Technical User
Joined
Aug 16, 2002
Messages
82
Location
US
I added some VBA code to a new Excel workbook, did some work in the workbook and everything ran perfectly closed and saved it. I came back the next day and now it will not let me run any macros, it says they are disabled and i have to enable them when the workbook opens but it doesn't ask me to enable the macros. This happens on every spreadsheet I created lately
 
Check Tools > Macro > Security and ensure your level is medium or low to run the macro.
 
That was it!! Security was set to high, i lowered it to medium and now it asks and I can enable the macros. THANK YOU!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top