Thread: Cell Entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default Cell Entry

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