Podcast Topic Idea !

[Russ At Index]

Hi All,

Bill , i enjoy your podcast publications

Please keep up the good work !

Here's a question ( If you have covered this off before
please accept my apologises )

I use several spreadsheets on an hourly basis, each spreadsheet
has a different colour to highlight the status of the row.
( if its coloured, then its finished , if not its not )

However when i open each sheet the colour font tab is always
yellow

Is there a way to "attach" a specific colour to a certain spreadsheet ?

Regards

Russ

 

[MrExcel]

This is strange - nothing should be changing the colour of the sheet tabs.

Two thoughts:
1) Is there a Workbook_Open macro in the book that resets all the sheet tabs colours? Try opening the workbook while holding down the Shift key to bypass any macros.

2) Does another co-worker have access to the book?

Bill