Posted to microsoft.public.excel.programming

dorre

external usenet poster

Posts: 12

unlocking problem

Hi

I have columns that are normally locked with protection on. But, I need to
have code that allows me to temporarily unluck column N. Why do I get an
error (1004: unable to set the locked property of the range class) with
this code?

Activesheet.Columns("N:N").Select
Selection.Locked = False

thanks
dorre

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
Unlocking right margin	GAleno2001	Excel Discussion (Misc queries)	0	December 6th 09 12:57 PM
unlocking a row	AJ	Excel Discussion (Misc queries)	3	February 26th 09 02:38 PM
Unlocking cells	maltagirl	Excel Discussion (Misc queries)	3	June 16th 08 07:20 PM
Unlocking in 97	Wes[_5_]	Excel Programming	4	October 17th 03 09:46 PM
Unlocking Cells	Sisilla	Excel Programming	1	July 18th 03 08:58 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us