Excel 2000 help please - Cell protection

[Steve Jones]

I have Excel 2003 and have created a spreadsheet for someone using Excel
2000.

In xl2003 within Tools/Protection there are tick box options for Select
locked cells, Select Unlocked cells etc.etc.

Was this something introduced in xl2003 or was it still available in xl2000?

I have set protection and ticked unlocked cells only. The person I sent the
spreadsheet to said he could access all cells even though he couldn't enter
information in the proteced cells.

I don't have access to xl2000

Within worksheet protection was "selecting unlocked cells only" available
and could someone tell me how to set this.


Thanks very much

 

[Dave Peterson]

That level of options in the sheet protection dialog was added in xl2002. So
you won't see it in xl2k.

You may be able to accomplish the same thing by using code:

Option Explicit
Sub Auto_Open()
With ThisWorkbook.Worksheets("Somesheetnamehere")
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True, Password:="hithere"
End With
End Sub

See VBA's help for the other options for .enableselection. (Many (most??) of
those items in the new xl2002+ sheet protection dialog aren't as easily
implemented in earlier versions of excel.)

And (I _think_) this is a a setting that isn't remembered after the workbook has
been closed. That's why I used the Auto_Open procedure. If macros are allowed
to run, then this will run when the workbook opens and do what you want.

 

[Steve Jones]

Thanks very much for that Dave

That level of options in the sheet protection dialog was added in xl2002.
So
you won't see it in xl2k.

You may be able to accomplish the same thing by using code:

Option Explicit
Sub Auto_Open()
With ThisWorkbook.Worksheets("Somesheetnamehere")
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True,
Password:="hithere"
End With
End Sub

See VBA's help for the other options for .enableselection. (Many (most??)
of
those items in the new xl2002+ sheet protection dialog aren't as easily
implemented in earlier versions of excel.)

And (I _think_) this is a a setting that isn't remembered after the
workbook has
been closed. That's why I used the Auto_Open procedure. If macros are
allowed
to run, then this will run when the workbook opens and do what you want.