I would like to be able to change the font color on worksheet 2,3,4,5, and 6 (titled GAVIN, MATANZO, SHAUB, GAYNOR and DOUGLAS, respectivley) and have it change the font color on worksheet 1 (titled MASTER). Probably not explaining it too well but my intent is for the manager of his particular unit to be able to change the font color under his tab and have the corresponding tab on the master sheet to change to that color font also. See attachment. Can anyone help?
Last edited by VBA Noob; 06-03-2008 at 02:15 AM.
Hello WhenUrAJet,
Do you want all the information from a total sheet to be in a color the manager chooses and have that same data on the master be in that color or only specific information?
Sincerely,
Leith Ross
Hello Leith,
I would like the managers to be able to change the font color for any employee in his division and have the corresponding cell in the master sheet change to that font color.
Haven't heard back for a while on my problem. I need a macro that will automatically change the font color in the corresponding cell of the first worksheet (MASTER), whenever I change the font color in any of the other worksheets. Any ideas?
Hello WhenUrAJet,
The attached workbook has the macro below installed to change the cell font colors to match, only for the RSR names. The macro is in the ThisWorkbook module Workbook_SheetChange event. This allows the same macro to be shared by all the worksheets. The macro is triggered whenever the RSR cell content is changed.
Sincerely,
Please Login or Register to view this content.
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks