PDA

View Full Version : Solved: VBA colours appearing as grey for other users



starsky
01-22-2010, 04:10 AM
Hi,

vbGreen appears as grey for other users of workbooks I provide. Is there any way around this, or am I restricted to the 56 colours of the standard palette?

Thanks.

Simon Lloyd
01-22-2010, 05:45 PM
What version of excel are you using and what version are the other users using?

markman123
01-22-2010, 09:38 PM
I have this very same issue at work. A database outputs to .xls files, and when you copy it to an .xlsx (2007) file, it changes the colour.

I suspect it's due to the different way that they handle the colour palette?

Mark

Simon Lloyd
01-22-2010, 10:47 PM
Check out this post by Andy Pope, he's created a function to call xl2003 colour palette. http://www.excelforum.com/2184501-post4.html

starsky
01-25-2010, 02:59 AM
Thanks Simon, will take a look

All 2003 versions in my case. On an individual workbook basis, I can insert a macro to run upon opening the file which resets the standard colours. This works fine. My next challenge will be to insert this macro to a range of new xl files automatically. Not sure this is possible - a macro to insert a macro?

Simon Lloyd
01-25-2010, 08:19 AM
Thanks Simon........ - a macro to insert a macro?Check out Chip Pearsons website, he has worked examples there to do just that :)

starsky
01-25-2010, 01:15 PM
There could be something useful there, thanks Simon.

Edit: Found some useful code there, and was able to insert an ActiveWorkbook.ResetColors based macro into the ThisWorkbook object. Thanks again.

Simon Lloyd
01-26-2010, 09:54 AM
There could be something useful there, thanks Simon.

Edit: Found some useful code there, and was able to insert an ActiveWorkbook.ResetColors based macro into the ThisWorkbook object. Thanks again.Thanks very much for posting back and letting us know :)