I need a work around for a protected worksheet

[Richard]

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?!?

 

[Gord Dibben]

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