Prevent sheet move

[kelster1]

Hi all, I have set up code that runs off a specific sheet number. The sheet number of sheets will change as the user runs through the operation, but the first three will remain where the code looks.

Is there any way I can fix the sheets positions so they cannot be moved manually?

Thanks in advance.

Simon

[way2020]

I am not sure if these 3 sheets are being updated or not. Assuming they do Not get updated the The protect sheet with a password may do what you want. If they are updated then VBA may help and that is beyond me.

Require a password to open or modify a workbook
Open the sheet or workbook that you want to protect.
On the Review tab, click Protect Sheet or Protect Workbook. Only the Protect Sheet.
In the Password box, type a password, and in the Verify box, type the password again.
Choose any other protection options you want and click OK.
Click Save.

Don't forget to say "Thank You" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

If this resolves your problem then click on Thread Tools at the top and mark it solved.

[kelster1]

Thanks way, the sheets are being updated and some of the names will change as the project progress so I cant use the named function either.

I have tried the password protect and It wont prevent the sheets moving positions within the workbook, it doesn't stop them from being accidently moved.

Thanks for responding.

[Marc L]

Hi,

use the sheet codename rather than sheet # or name
so even if the sheets order is changed or a sheet renamed that is very not an issue like you can see in VBA help …