Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to change the color of a cell if a sheet is protected? I want
to place an object on a worksheet that will turn protection on or off if a cell indicates that the sheet is protected. I dont want users going to the menu to perfom this function because I'm tired of unprotecting sheets that have forget passwords assigned. -- Regards... |
#2
![]() |
|||
|
|||
![]()
Hi
record a macro and assign this macro to a toolbar icon -- Regards Frank Kabel Frankfurt, Germany "cincode5" schrieb im Newsbeitrag ... Is there a way to change the color of a cell if a sheet is protected? I want to place an object on a worksheet that will turn protection on or off if a cell indicates that the sheet is protected. I dont want users going to the menu to perfom this function because I'm tired of unprotecting sheets that have forget passwords assigned. -- Regards... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |