excel vbs colourcolor palette
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel (VBS): Colour/Color Palette

Excel (VBS): Colour/Color Palette

resolvedResolved · Low Priority · Version 2003

replyReply Fri 15 May 2009, 11:10Delegate Simon said...

Simon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel (VBS): Colour/Color Palette

I'm not sure if this is a bit left field, but we did touch on colour properties on both VBA courses.

I produce spreadsheet tools for dissemination. I use a color palette recommended for visual imparement. In the majority of cases this works fine. But I notice that a different colour scheme displays on a few machines. I assume that the palatte has reverted to Excel standard.

Is there a simple line of code to 'lock in' a modified color palette to a spreadsheet that will be used on multiple machines? Or should I define the whole palette (or, at least, the colours that need to be different from the standard palette) in VBA?

Cheers,

S!

For upcoming training course dates see: Pricing & availability

replyReply Tue 19 May 2009, 09:20Trainer Jacob said...

RE: Excel (VBS): Colour/Color Palette

Hi Simon

Thanks for your post, a very interesting one too!

I have checked with one of my team on this who runs the Excel VBA courses and they feel that we would need some time allocated to research for any solutions as well as possibly having a look at your files.

This will take us outside the general parameters of this forum but if you would like to look at progressing this please let me know and we can discuss options.

Regards

Jacob

 

Please browse our web site to find out more about
introduction excel training and other Microsoft training courses.

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard