H
Howman
How do you stop protected cells from being selected on a worksheet in excel ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dan Hatola
If you use VBA, you can set the enableselection property for the cells.
For instance:
Sheet1.EnableSelection = xlUnlockedCells
This will allow selection in only the unlocked cells.
Dan
For instance:
Sheet1.EnableSelection = xlUnlockedCells
This will allow selection in only the unlocked cells.
Dan
S
Saruman
When the cells are being protected using Tools,Protection, Protect Sheet,
de-select the tick box in the allow users to select area for the Locked
Cells Option.
Remember that by default, all cells in Excel are Locked.
--
Saruman
---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------
de-select the tick box in the allow users to select area for the Locked
Cells Option.
Remember that by default, all cells in Excel are Locked.
--
Saruman
---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------
excel ?Howman said:How do you stop protected cells from being selected on a worksheet in
D
Dan Hatola
I have seen that as an option in Excel 2003, but is it possible in earlier
versions of Excel without using VBA?
Dan
versions of Excel without using VBA?
Dan