Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I upgraded to Office 2010. I have some Excel spreadsheets that contain macros that I would like to run. When I save the workbook as an excel macro enabled workbook it doesn't work. I get an error box that pops up saying that the macros have been disabled.

I checked the macro security settings and this is what I found: enter image description here

It looks like the only option is to either enable or disable totally. Now the one that is checked it mentions except digitally signed macros. How is this done, and is this the only way I can run my spreadsheets that contain macros?

share|improve this question

migrated from Apr 23 '11 at 22:29

This question came from our site for professional and enthusiast programmers.

up vote 0 down vote accepted

You can also enable all macros, the not recommended just explains that if you do download an office file containing macros you don't know it could be dangerous as they could automate certain activities that could be harmful.

I usually just enable all the macros though, get's rid of the "UAC" style restrictions and let's you use Macros whenever you want.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .