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 |
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 |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com