Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Protection
I have approximately 200 cells that I would like to have protected so
users cant be edit or delete them. I would like my users to be able to move these protected cells into different columns or rows (By Drag and Drop), just not edit them or delete them. Is this possible? How? Thanks Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Protection
Hi is there any way the following code can be amended to prevent
acces to a range of cells ... say B9:B20 ? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$9" Then '<===change this if you wish Range("A1").Select End If End Sub can you please advise of the correct syntax as I've tried If Target.Address = "$B$9: $B$20" Then ... would does not work Any help would be appreciated Many thanks Ro -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Cell Protection | Excel Worksheet Functions | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) |