Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protected sheets and cells
I have a timesheet that I have designed and want protected against the
employees from changing except for adding their time. Which I have done. I have the sheet protected, except for these and other unique cells. One such is a supervisors signature cell I was hoping to enable them to insert thier signature (a jpeg picture) into while leaving the entire sheet protected, with just this particular cell unlocked. Is what I'm trying to do possible? |
#2
|
|||
|
|||
Protected sheets and cells
Give the manager a "private" shortcut key. That shortcut key combination
should run a macro that: a) unprotects the sheet b) inserts the graphic c) reprotects the sheet You can record that macro, too. http://www.officearticles.com/excel/...soft_excel.htm Then assign the shortcut key to it (something like Ctrl+Shift+S would be good): http://www.officearticles.com/misc/m...ica tions.htm ************ Anne Troy www.OfficeArticles.com "HRMSN" wrote in message ... I have a timesheet that I have designed and want protected against the employees from changing except for adding their time. Which I have done. I have the sheet protected, except for these and other unique cells. One such is a supervisors signature cell I was hoping to enable them to insert thier signature (a jpeg picture) into while leaving the entire sheet protected, with just this particular cell unlocked. Is what I'm trying to do possible? |
#3
|
|||
|
|||
Protected sheets and cells
Just go to format cell..protection..and chose "unlock". Excel defaults
locking all cells so if you "unlock" it and protect the sheet it will work. I do it all the time. Good luck. James "HRMSN" wrote: I have a timesheet that I have designed and want protected against the employees from changing except for adding their time. Which I have done. I have the sheet protected, except for these and other unique cells. One such is a supervisors signature cell I was hoping to enable them to insert thier signature (a jpeg picture) into while leaving the entire sheet protected, with just this particular cell unlocked. Is what I'm trying to do possible? |
#4
|
|||
|
|||
Protected sheets and cells
Hey Anne,
I tried what you recommended, but when I tried to run the macro, it indicated that macros don't work on protected sheets. What am I doing wrong? "Anne Troy" wrote: Give the manager a "private" shortcut key. That shortcut key combination should run a macro that: a) unprotects the sheet b) inserts the graphic c) reprotects the sheet You can record that macro, too. http://www.officearticles.com/excel/...soft_excel.htm Then assign the shortcut key to it (something like Ctrl+Shift+S would be good): http://www.officearticles.com/misc/m...ica tions.htm ************ Anne Troy www.OfficeArticles.com "HRMSN" wrote in message ... I have a timesheet that I have designed and want protected against the employees from changing except for adding their time. Which I have done. I have the sheet protected, except for these and other unique cells. One such is a supervisors signature cell I was hoping to enable them to insert thier signature (a jpeg picture) into while leaving the entire sheet protected, with just this particular cell unlocked. Is what I'm trying to do possible? |
#5
|
|||
|
|||
Protected sheets and cells
Paste your code. :)
************ Anne Troy www.OfficeArticles.com "HRMSN" wrote in message ... Hey Anne, I tried what you recommended, but when I tried to run the macro, it indicated that macros don't work on protected sheets. What am I doing wrong? "Anne Troy" wrote: Give the manager a "private" shortcut key. That shortcut key combination should run a macro that: a) unprotects the sheet b) inserts the graphic c) reprotects the sheet You can record that macro, too. http://www.officearticles.com/excel/...soft_excel.htm Then assign the shortcut key to it (something like Ctrl+Shift+S would be good): http://www.officearticles.com/misc/m...ica tions.htm ************ Anne Troy www.OfficeArticles.com "HRMSN" wrote in message ... I have a timesheet that I have designed and want protected against the employees from changing except for adding their time. Which I have done. I have the sheet protected, except for these and other unique cells. One such is a supervisors signature cell I was hoping to enable them to insert thier signature (a jpeg picture) into while leaving the entire sheet protected, with just this particular cell unlocked. Is what I'm trying to do possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
navigational keys in protected sheets | Excel Discussion (Misc queries) | |||
How do I sort protected cells? | Excel Discussion (Misc queries) | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Protected sheets | Excel Worksheet Functions |