March 2011
6 posts
Developer Macro Settings
I wrote a VBA subroutine in Excel 2007 to report on the contents of the VBA Project on a worksheet so I could see the number of modules, lines of code, etc.
Then I tried to run this macro with Excel 2010 and it wouldn’t execute. It finally dawned on me that you have to allow access to the VBA project in Settings.
So I had to choose Developer > Macro Security and check the box to Trust...
Word to the Wise
Don’t think about VBA programming code when you’re taking your contact lenses out at night. You just might find out in the morning the left contact is in the right eye, and the right contact is in the left eye.
An Excel Dashboard Resource
For a number of years I created reports and charts for the printing industry. Since my work as a consultant was limited to a relatively short time period, the basic Key Performance Indicators were covered before we moved on to the next project.
I just started reading Excel Dashboards and Reports (Mr. Spreadsheet’s Bookshelf) and found some seriously good stuff in the introduction chapter....
F2 in Excel for Mac →
Seems a hot topic today.
Switch Between Workbooks Faster in Excel 2007 and... →
