The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You can also choose to recognize the publisher as a trusted source. Click the office button and scroll down to Excel options. Click on the trust center option and go to trust center settings. Then, view the trusted locations and choose an folder. You can also go to the macro settings and select disable macros with all notifications. Then click OK. Save the settings. Click on the options to see the security information. Then, toggle the trust all documents from this publisher option. Click OK. The macros will now correctly work in the spreadsheet.
Home
Microsoft Office How to Enable macros in Excel to run correct spreadsheets

By Sean Conaty
Apr 21, 2010 07:27 PM
You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.
Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.
Comments
Be the first, drop a comment!