Posted to microsoft.public.excel.programming

kirkm[_6_] kirkm[_6_] is offline

external usenet poster

Posts: 156

Read-Only

On Mon, 5 Mar 2007 16:24:18 -0800, Jay
wrote:

Sub kirkm()
For Each ws In ActiveWorkbook.Sheets
ws.Protect
Next 'ws
End Sub

To unprotect them, change the term "Protect" to "Unprotect". Or you can
manually unprotect each sheet using Excel's menu: Tools|Protection|Unprotect
Sheet...

Thanks Jay, that just what I wanted. Haven't got any locked
cells so that shouldn't be a factor.

Cheers - Kirk.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
I have a read only xl file, I need it to be read and write	drama queen	Excel Discussion (Misc queries)	3	July 1st 06 12:25 AM
Read-write/Read-only	Jillian	Excel Discussion (Misc queries)	4	February 16th 06 05:26 PM
XCEL FILE REC'D AS READ ONLY -- HOW TO NOT BE "READ ONLY"	billybob	Excel Discussion (Misc queries)	1	February 13th 06 03:14 AM
How can a file be converted from Read-Only to Read/Write	Jim in Apopka	Excel Discussion (Misc queries)	2	November 19th 05 04:59 PM

All times are GMT +1. The time now is 10:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us