Block access to freeze pane & Default view

Hi,

i'm wondering if any vba exist to block the freeze pane option?

We have a file with multiple users in, and some are not really good with excel and temper with freeze panes. I would love the option to be blocked, and only editable by me.

I'm wondering if we can also lock that tab default view to not be editable, people put filters there and mess up the default view so when people open the file it's full of filters because they didnt use temporary view.

If you put this into ThisWorkbook code:

Please Login or Register  to view this content.

it switch off freeze panes when user change sheet and set according to your settings. You can put some conditions depends of sheet name where to select before you turn it into TRUE.