Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Apr 23 '11 at 22:29

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

add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.