Posted to microsoft.public.excel.programming

Sarah[_4_] Sarah[_4_] is offline

external usenet poster

Posts: 11

Making cells readonly

I have a spreadsheet that I am working with in VBA. I have tried making the sheet read only after populating it by using the following code
For i = 1 to
sheet1.Columns(i).Locked = Tru
Nex

However, I am still able to edit all cells. Is there some other syntax that I should use? Can't figure out why this won't work

Thanks much

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
Changing file from readonly	Niall	Excel Discussion (Misc queries)	2	July 27th 06 04:58 PM
Readonly files	nc	Excel Discussion (Misc queries)	2	March 18th 05 11:13 AM
Open As Readonly	SCSC[_2_]	Excel Programming	5	February 4th 04 05:14 PM
Closing ReadOnly file using VBA	acces	Excel Programming	1	January 15th 04 08:59 PM
Change ReadOnly State	Jos Vens	Excel Programming	2	November 17th 03 10:35 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us