Posted to microsoft.public.excel.programming

SueJB

external usenet poster

Posts: 38

Unprotect column

Hi all

I have a worksheet that is either unprotected (to allow editing) or
protected (to allow viewing only) depending on a user login and password.
However, unprotection allows access to the entire sheet and now I need to
permit one user to edit one column only.

Is there a way to unprotect a single column in an otherwise protected
worksheet?

Thanks in advance!
SB

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
Unprotect a worksheet	Mayumdwl	Excel Worksheet Functions	1	April 21st 09 12:30 AM
Unprotect in a macro	Partly Void[_2_]	Excel Discussion (Misc queries)	3	October 5th 08 10:45 AM
unprotect subtotals	[email protected]	Excel Worksheet Functions	1	November 22nd 07 01:03 PM
Unprotect	Conditional Formatting	Excel Discussion (Misc queries)	3	September 5th 05 02:49 PM
Password Unprotect	Bob Tulk	Excel Programming	0	July 29th 03 02:53 PM

All times are GMT +1. The time now is 04:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us