Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 help please - Cell protection
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 help please - Cell protection
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 wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 help please - Cell protection
Thanks very much for that Dave
"Dave Peterson" wrote in message ... 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 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change protection of a shared workbook (Excel 2000) | Excel Discussion (Misc queries) | |||
cell protection in Excel 2000 | Excel Discussion (Misc queries) | |||
EXCEL PROTECTION 2000 | Excel Discussion (Misc queries) | |||
Cell Protection over Excel 2000 and 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 Protection | Excel Discussion (Misc queries) |