Posted to microsoft.public.excel.programming

Chip Pearson Chip Pearson is offline

external usenet poster

Posts: 7,247

Locking cells

Ian,

Try something like

Range("A1").Locked = True ' or False

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Ian Coates" wrote in message
...
Is there a way to lock a cell using VBA?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
locking cells	rwbaker	Excel Discussion (Misc queries)	3	April 27th 10 01:02 PM
Locking Cells	gpros32	Excel Worksheet Functions	9	October 9th 08 02:55 PM
locking the cells	Rajesh Chandra	Excel Discussion (Misc queries)	1	August 26th 08 09:06 AM
Locking certain cells	Beverly Darvill[_2_]	Excel Discussion (Misc queries)	3	June 11th 08 05:10 PM
locking formula in cells in without locking whole sheet	SuziQ	Excel Discussion (Misc queries)	1	July 21st 06 03:58 PM

All times are GMT +1. The time now is 08:11 PM.

About Us

"It's about Microsoft Excel"