Forum Discussion
Locking the sheets within a spread sheet to prevent moving
I am trying to figure out how to lock the sheets within the spreadsheet to prevent them from moving around whenever someone clicks on them. Is there a way to do that without locking the whole spreads...
At first sight, 'Protect Workbook' would appear to do what you require.
PeterBartholomew1 I saw that, but it wasn't clear if the workbook is still able to be used the same way. Do you know if you are still able to work in the "live" version of the workbook, if the sheets are locked?
As far as I know, formulas and data may still be changed without hinderance. Just do it and try; don't forget the password though!