Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort protected worksheet in Excel 07? Doesn't work. | Excel Worksheet Functions | |||
Protected work shet | Excel Discussion (Misc queries) | |||
"Show all" button not work in protected worksheet | Excel Worksheet Functions | |||
Can't Get Objects To Work In A Protected Worksheet | Excel Worksheet Functions | |||
Why doesn't spell check work on a protected worksheet? | Excel Worksheet Functions |