I have code in the same colum on 5 diffent sheets, and i dont want anyone to be able to change the code.
Is it possible to lock single columns on different sheets so the code cannot be edited?
I have code in the same colum on 5 diffent sheets, and i dont want anyone to be able to change the code.
Is it possible to lock single columns on different sheets so the code cannot be edited?
I take it by "code" you mean formulae? of course its possible in a number of ways. You can select the entire sheet and unlock all cells then select your coulmn and lock all cells and hide formula, you would then have to protect the worksheet for this to be in force or you could go the VBA route and not allow the user to select any cell in that column!
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks