|
|
Macro
Here is a macro so you can instantly do this to any sheet. Just paste it into a new macro module (alt-F11; Insert->Module), preferably in your "Personal Macro Workbook" for all the time access.
Note the single quote is a comment tag. Remove it if you prefer to suppress gridlines. You could also record your own macro (that is what I did for the code above) with your own customizations.
Macro
I have been able to run the macro on the sheet I have open, but how do I get the macro to live in all new documents I create?
Macro
From Excel Help: |
SearchFrom our Sponsor...Latest Mountain Lion HintsWhat's New:HintsNo new hintsComments last 2 daysLinks last 2 weeksNo recent new linksWhat's New in the Forums?
Hints by TopicNews from Macworld
From Our Sponsors |
|
Copyright © 2014 IDG Consumer & SMB (Privacy Policy) Contact Us All trademarks and copyrights on this page are owned by their respective owners. |
Visit other IDG sites: |
|
|
|
Created this page in 0.13 seconds |
|