View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Richard Richard is offline
external usenet poster
 
Posts: 709
Default 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?!?