Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locking cells
Hello,
I am wondering if there is a way to just protect cells so text cannot be changed? without having the msgbox coming up that states that the cells are protected? Or is there a way to suppress that message box from popping up? even when protection is on? thanks for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
locking cells
When you go to protect the sheet, deselect the tick box that says "Select
Locked Cells". Then you won't be able to actual have that cell selected and attempt to change it. The problem comes when you try double clicking on that locked cell as it will still pop up the message. Sorry I couldn't have been more help. "greg" wrote: Hello, I am wondering if there is a way to just protect cells so text cannot be changed? without having the msgbox coming up that states that the cells are protected? Or is there a way to suppress that message box from popping up? even when protection is on? thanks for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
locking cells
If you use xl2002+, you'll see two options under:
tools|protection|protect sheet to allow users to select locked cells and to allow users to select unlocked cells. If you're using xl2k or earlier, you can protect the worksheet in code: Sub Auto_Open() With Worksheets("Sheet99999") .Unprotect Password:="hi" .EnableSelection = xlUnlockedCells .Protect Password:="hi", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End With End Sub In xl2k and below, this setting isn't remembered when you close the workbook and reopen. Setting it in code was the only way to do this. greg wrote: Hello, I am wondering if there is a way to just protect cells so text cannot be changed? without having the msgbox coming up that states that the cells are protected? Or is there a way to suppress that message box from popping up? even when protection is on? thanks for any help -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
locking cells
Thanks,
I will take a look at both. "greg" wrote in message ... Hello, I am wondering if there is a way to just protect cells so text cannot be changed? without having the msgbox coming up that states that the cells are protected? Or is there a way to suppress that message box from popping up? even when protection is on? thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells | New Users to Excel | |||
Locking Cells | Excel Worksheet Functions | |||
Locking Cells | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking cells | Excel Programming |