Solved: VBA colours appearing as grey for other users

[starsky]

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]

What version of excel are you using and what version are the other users using?

[markman123]

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]

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]

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]

Thanks Simon........ - a macro to insert a macro?

Check out Chip Pearsons website, he has worked examples there to do just that

[starsky]

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]

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