Member Avatar for Luma

Hi All!! Plse HELP!!

I need to avail various ranges on different sheets in an in Excel 2003 workbook for users to type in. However, I need the cells to be locked upon saving of workbook. How do I do it?

Thanks
Luma

  • 2 Contributors
  • 2 Replies
  • 114 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Luma
Member Avatar for joshSCH

Tools-protection gives you 'locking' options.. is this what you mean?

Member Avatar for Luma

Hi joshSCH,

No. What I mean is that I need a script/code than runs "on change" locking only the changed cells. In other words, the user should be able to complete certain ranges, and upon saving, the changed (completed) cells should be locked, preventing future editting.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.