If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need a work around for a protected worksheet
I have a document (many cells of which are protected) that I'd like to insert
either a button or other feature such that when a person reviews the document they can click (or otherwise activate the feature) to run a macro (or hyperlink?) to insert a scanned copy of their signature in a specific cell. I am able to make this work when the worksheet protection is turned off (unprotected) but when I turn the protection back on, the macro won't run. I've tried putting the macro in unprotected (unlocked) cells but when protection is on for the whole page, the macro still won't run. Is there a way around this?!? |
#2
|
|||
|
|||
I need a work around for a protected worksheet
Richard
I assume the macro will run when the sheet is protected but throws an error. A scanned copy of a signature is an object. Objects, like a picture, cannot be inserted "into a cell", only lay on top of a cell or cells. With 2002 and newer you can allow the insertion of an object on a protected sheet by selecting "Edit Objects" when protecting the sheet. When writing the insertion macro assign a screen location to the object. Gord Dibben MS Excel MVP On Fri, 21 Dec 2007 12:22:02 -0800, Richard wrote: I have a document (many cells of which are protected) that I'd like to insert either a button or other feature such that when a person reviews the document they can click (or otherwise activate the feature) to run a macro (or hyperlink?) to insert a scanned copy of their signature in a specific cell. I am able to make this work when the worksheet protection is turned off (unprotected) but when I turn the protection back on, the macro won't run. I've tried putting the macro in unprotected (unlocked) cells but when protection is on for the whole page, the macro still won't run. Is there a way around this?!? |
Thread Tools | |
Display Modes | |
|
|