I have VBA code that updates protected cells in a protected worksheet. The
user selects the cells to update. How do I restrict this update to certain
cells only? Do I have to check if the selected cell (ActiveCell) is within a
certain range of cells? What is the best way to do this? Thank you.
--
Ed

Can you elaborate a bit?
Do you have more than one user?
Do different users' have access to different cells or do all users get
access to the same cells? If this is the case, do you want to simply unlock
the cells that users can edit, then protect the sheet?


"Ed" wrote:

I have VBA code that updates protected cells in a protected worksheet. The
user selects the cells to update. How do I restrict this update to certain
cells only? Do I have to check if the selected cell (ActiveCell) is within a
certain range of cells? What is the best way to do this? Thank you.
--
Ed

Only one user. To elaborate, I have drop down and scroll boxes and standard
command boxes occupying some of the space where cells a1 to g12 reside. I
want the user to only select cells in the 'free' area of a14 to g22.
Currently they can also select cells in a1.g12.
Thinking I need to get the active cell and if it is outside the a14.g22
area, then give them a msg to select only in the requested area. Else,
continue processing the update. Just not sure how best to do this.
The way I wrote this, all cells on the sheet are protected. The cells in
a14.g22 simply show an update from another worksheet. But I want this update
to only show in the a14.g22 cells. Hope this explains it. Thanks.

"gocush" wrote:

Can you elaborate a bit?
Do you have more than one user?
Do different users' have access to different cells or do all users get
access to the same cells? If this is the case, do you want to simply unlock
the cells that users can edit, then protect the sheet?


"Ed" wrote:

I have VBA code that updates protected cells in a protected worksheet. The
user selects the cells to update. How do I restrict this update to certain
cells only? Do I have to check if the selected cell (ActiveCell) is within a
certain range of cells? What is the best way to do this? Thank you.
--
Ed