Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protected sheets
Is there a way to insert a graphic or run a macro if a worksheet is
protected? I am trying to enable a supervisor to insert their signature to a timesheet without allowing them to unprotect, and therefor possibly change, the worksheet. |
#2
|
|||
|
|||
Protected sheets
Here's a thought --
Before you protect the sheet, you can specify a range that users are allowed to alter. You can even define the specific users allowed to do that. Set up a range into which your supervisor can paste his/her electronic signature, then protect the rest of the sheet. Let me know if it works. Peter "HRMSN" wrote: Is there a way to insert a graphic or run a macro if a worksheet is protected? I am trying to enable a supervisor to insert their signature to a timesheet without allowing them to unprotect, and therefor possibly change, the worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
navigational keys in protected sheets | Excel Discussion (Misc queries) | |||
Index of protected sheets | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Can't open protected sheets | Setting up and Configuration of Excel | |||
Protected sheets | Excel Worksheet Functions |