Hide column and password protect

bskipper 

Maybe I can help you with this information.
There are several ways to do this.

One of them is VBA (caution: not all excel / office versions can run VBA). there, in turn,

there are many sub-possibilities to accomplish this.

Example with a button, with a time lapse, with a click on a certain cell, etc.

Here a Simple macro for leaf protection Blade protection.

Press the ALT and F11 keys at the same time so that Excel immediately shows you the VBA editor window.

Sub blade protection ()
     ActiveSheet.Protect Password: = "Password Name", UserInterfaceOnly: = True, DrawingObjects: = True, Contents: = True, Scenarios: = True
End Sub

Sub Blade Protection Off ()
     ActiveSheet.Unprotect Password: = "Password Name"
End Sub

If you want to switch off the blade protection in a macro, you can do this in the macro with "Call Blade Protection Off" and activate it again with "Call Blade Protection".
If you assign a key combination to the macros e.g. (Ctrl + b) then you can quickly turn off the sheet protection u. turn on.
Hope you can do something with it.

-----------------------------------------------

There is also the possibility to do the half manually by changing the protection worksheet at the desired moment.

Protect a workbook

https://support.microsoft.com/en-gb/office/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517?ui=en-us&rs=en-gb&ad=gb

Protect a worksheet

https://support.microsoft.com/en-gb/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6?ui=en-us&rs=en-gb&ad=gb

You can change the language during these times by scrolling down and changing the language on the right.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.