Hi Guys,
I'm trying to make a spreadsheet more secure to prevent unintentional changes.
What i'm looking to do is to lock all cells so no changescan be made unless the user clicks column A.
Column A should remain unlocked and when the user clicks it i would like the entire row unlocked for editing (but only after column A is clicked)
I will run a macro to lock the entire sheet again once the sheet closes.
can anyone help with this or point me in the right direction?
many thanks











LinkBack URL
About LinkBacks

Register To Reply
Bookmarks