protected sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shlomit - 21 Nov 2006 13:03 GMT

I protected sheet in macro with the following code but not all the column was
protected?

Worksheets("GiveGetDB").Protect Contents:=True

Any one can help?

Thanks,
shlomit

Reply to this Message

Dave Peterson - 21 Nov 2006 13:37 GMT

If some of the cells in those columns are unlocked (format|Protection tab), then
those cells can still be changed.

> I protected sheet in macro with the following code but not all the column was
> protected?
[quoted text clipped - 5 lines]
> Thanks,
> shlomit

Signature

Dave Peterson

Reply to this Message

Nick Hodge - 21 Nov 2006 13:38 GMT

Shlomit

Are the cells unlocked? Protection will only work if the cells are also
locked

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

>I protected sheet in macro with the following code but not all the column
>was
[quoted text clipped - 6 lines]
> Thanks,
> shlomit

Reply to this Message

Shlomit - 22 Nov 2006 20:56 GMT

So how can I lock all the cells and protected the sheet in the macro?

Thanks,
Shlomit

> Shlomit
>
[quoted text clipped - 11 lines]
> > Thanks,
> > shlomit

Reply to this Message

Gord Dibben - 22 Nov 2006 21:17 GMT

To lock all the cells and protect the sheet........

Sub SHEETPROTECT()
With ActiveSheet
.Cells.Locked = True
.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End With
End Sub

Gord Dibben MS Excel MVP

on Wed, 22 Nov 2006 12:56:01 -0800, Shlomit <Shlomit@discussions.microsoft.com>
wrote:

>So how can I lock all the cells and protected the sheet in the macro?
>
[quoted text clipped - 16 lines]
>> > Thanks,
>> > shlomit

Reply to this Message

Rate this thread: