Forum Discussion
Hide column and password protect
I am needing to hide a column until I am finished working on it. I share the workbook with others to select inventory parts and one part is not ready to release until I receive some information henc...
Enclosed the file with the VBA code.
Wasn't previously correctly described as a sub.
Also attached is the VBA code.
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
It's always difficult to understand what it was about after such a long time, but now it's OK 🙂
It also took a year :))
Hope this information could help you.
Wish you a nice day...and year :).
I know I don't know anything (Socrates)
Thank you so kindly answering. I wish you a lot of joy , health and a lot of Gaudi all over this Happy New Year too. Now I need your help again. I am not experienced in handling the communication with Microsoft Tech Community. Surely I want to give you a like to your answer as I wanted yesterday for your answer over a year ago - and not recognized by me. Could you please tell me how I get it done 🙂