LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
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?!?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort protected worksheet in Excel 07? Doesn't work. jbachaud Excel Worksheet Functions 1 June 1st 07 06:43 PM
Protected work shet Stuart Carnachan Excel Discussion (Misc queries) 2 August 30th 06 04:16 PM
"Show all" button not work in protected worksheet Marisa Excel Worksheet Functions 0 June 16th 06 05:16 AM
Can't Get Objects To Work In A Protected Worksheet OMMBoy Excel Worksheet Functions 2 May 27th 06 06:28 PM
Why doesn't spell check work on a protected worksheet? Creating Order Forms is Fun Excel Worksheet Functions 6 December 22nd 04 07:34 PM


All times are GMT +1. The time now is 06:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"