Color banding
How do I apply color banding in a spreadsheet? I see how it is used here
http://office.microsoft.com/en-us/ex...CL100570551033 but do not know how to apply this. |
Color banding
Right-click on the worksheet tab you want it to apply to and select "View Code" Copy and paste the code from your link into the white editor window. Close the editor. Now test on your sheet. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111004 |
Color banding
Also dont forget to set the Security level to low/medium in
(Tools|Macro|Security). If this post helps click Yes --------------- Jacob Skaria "DJTrainer76" wrote: How do I apply color banding in a spreadsheet? I see how it is used here http://office.microsoft.com/en-us/ex...CL100570551033 but do not know how to apply this. |
All times are GMT +1. The time now is 03:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com