I would also like to add the following which was the only thing to solve my problem, which also threw up the 'macro' issue. Although they discuss Office 2007, it certainly worked for me on Office 2010 (to my great relief). Obtained from http://www.eggheadcafe.com/software/aspnet/33418494/the-function-you-are-attempting-to-run-contains-macros-or-content.aspx
"Here's the best way. Open the Control Panel, double-click Programs &
Features, find and select Office 2007. Click on the Change button (at the
top of the screen) and Office Setup will launch itself. Chose Add or Remove
Features. From the list, expand Office Shared Features, click on the little
arrow attached to Visual Basic for Applications and select the Run from My
Computer Option. Click Continue. Setup will then install the VBA code that
you need.
Note that this is NOT done in Word. Word and all Office apps should be
closed."
Upgrade Storage
"Here's the best way. Open the Control Panel, double-click Programs &
Features, find and select Office 2007. Click on the Change button (at the
top of the screen) and Office Setup will launch itself. Chose Add or Remove
Features. From the list, expand Office Shared Features, click on the little
arrow attached to Visual Basic for Applications and select the Run from My
Computer Option. Click Continue. Setup will then install the VBA code that
you need.
Note that this is NOT done in Word. Word and all Office apps should be
closed."