Hi domc,
In Excel 2007 Microsoft introduced 'Tint and Shade' and a lot of other fancy color attributes, which I try to ignore. I am just interested in colors. I use the following macros to determine colors of Shapes and Cells. I prefixed 'aaa' in front of the Macro names so they would be at the top of the list when I press 'Alt F8' to display Macros.
Excel 2011 is for the Mac, so I do not know if the following Windows Macros will work for you.
To access Visual Basic (VBA) see:
http://www.ablebits.com/office-addin...a-macro-excel/
a. Click on any cell in the Excel Spreadsheet (may not be needed).
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module.
4. To add a module in the VBA Editor:
a. 'Left Click' on any cell in the Excel Spreadsheet.
b. ALT-F11 to get to VBA.
c. CTRL-R to get project explorer (if it isn't already showing).
d. 'Right Click' on the Project or on any module in 'Project Explorer'.
e. Insert > Module
f. To rename the Module press 'F4' to access the 'Properties' Window (if the 'Properties' Window is not already visible)
g. To the right of the (Name) Property, type in the New Name. The name MUST be unique and VBA must be DORMANT (i.e. no Macros running).
You can now 'cut and paste' code into the module.
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:
This option requires all variables to be declared and will give a compiler error for undeclared variables.
I hope this helps.
Lewis
Bookmarks