Posted to microsoft.public.excel.programming

gavmer[_80_] gavmer[_80_] is offline

external usenet poster

Posts: 1

Unprotect via prompt

Hi all,

have a protected sheet that a user may need to amend. I therefore nee
a click event that will prompt for a password and unprotect the shee
so they can enter info. ANother click event to reprotect the sheet.

Thanks in advance all!!!!

--
gavme
-----------------------------------------------------------------------
gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666
View this thread: http://www.excelforum.com/showthread.php?threadid=26268

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
save prompt for user exit, but no save prompt for batch import?	lpj	Excel Discussion (Misc queries)	1	February 25th 06 02:08 AM
Unprotect	Conditional Formatting	Excel Discussion (Misc queries)	3	September 5th 05 02:49 PM
The UNPROTECT option	Unprotect option inactive	Excel Worksheet Functions	3	April 22nd 05 07:23 PM
unprotect worksheet	Richard Sanchez	Excel Programming	1	July 17th 04 01:26 AM
Protecting Multiple sheets with prompt for password to unprotect	pkley	Excel Programming	1	January 10th 04 06:46 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us