Forum Discussion

bskipper's avatar
bskipper
Copper Contributor
Feb 20, 2019

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...
Eifeltarzan's avatar
Eifeltarzan
Copper Contributor
Jan 01, 2022
Nun Habe ich das Beispiel Makro übernommen. Erhalte aber einen Fehler bei der Ausführung. 'Sub blade protection ()' ist rot markier' und ich erhalte 'Fehler beim Kompilieren. Anweisungsende fehlt."
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jan 01, 2022

    Eifeltarzan 

    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 :).

    Nikolino

    I know I don't know anything (Socrates)

    • Eifeltarzan's avatar
      Eifeltarzan
      Copper Contributor
      Jan 01, 2022
      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 🙂

Resources