Hide column and password protect

%3CLINGO-SUB%20id%3D%22lingo-sub-354118%22%20slang%3D%22en-US%22%3EHide%20column%20and%20password%20protect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354118%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20needing%20to%20hide%20a%20column%20until%20I%20am%20finished%20working%20on%20it.%26nbsp%3B%20I%20share%20the%20workbook%20with%20others%20to%20select%20inventory%20parts%20and%20one%20part%20is%20not%20ready%20to%20release%20until%20I%20receive%20some%20information%20hence%20why%20I%20would%20like%20to%20lock%20or%20password%20protect%20the%20hidden%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20away%20to%20set%20a%20password%20after%20hiding%20the%20column%20or%20columns%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357123%22%20slang%3D%22en-US%22%3ERE%3A%20Hide%20column%20and%20password%20protect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357123%22%20slang%3D%22en-US%22%3EYou've%20posted%20in%20the%20Community%20Discussion%20space%2C%20meant%20for%20questions%20directly%20about%20the%20Tech%20Community.%20I've%20moved%20your%20question%20to%20the%20Excel%20space%20for%20better%20visibility.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1712262%22%20slang%3D%22de-DE%22%3ERE%3A%20Hide%20column%20and%20password%20protect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1712262%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F41707%22%20target%3D%22_blank%22%3E%40Eric%20Strong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20Eric%2C%20I%20have%20the%20same%20question%20as%20bskipper%20but%20cannot%20find%20your%20answer.%20I%20need%20to%20hide%20one%20column%20in%20a%20worksheet%20that%20only%20is%20visible%20to%20me%20in%20case%20I%20have%20to%20change%20some%20data%20there.%3C%2FP%3E%3CP%3EI%20am%20not%20familiar%20with%20this%20app.%20Pardon%20me%20in%20case%20I%20don't%20use%20it%20and%20the%20English%20correctly.%3C%2FP%3E%3CP%3EThanks%20ahead%20for%20answering%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 hence why I would like to lock or password protect the hidden column.

 

Is there away to set a password after hiding the column or columns?

4 Replies
Highlighted
You've posted in the Community Discussion space, meant for questions directly about the Tech Community. I've moved your question to the Excel space for better visibility.
Highlighted

@Eric Starker 

Hello Eric, I have the same question as bskipper but cannot find your answer. I need to hide one column in a worksheet that only is visible to me in case I have to change some data there.

I am not familiar with this app. Pardon me in case I don't use it and the English correctly.

Thanks ahead for answering

Highlighted

@Eifeltarzan Sorry for any confusion!

You are correct, I didn't answer the question. The question was originally posed in an incorrect part of the Tech Community, so I moved it to the correct one.

 

I am a community manager here in the Tech Community and not a product expert, so I'll leave this question to one of the Excel product experts! I hope you find a response soon.

Highlighted

@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?u...

 

Protect a worksheet

https://support.microsoft.com/en-gb/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6?...

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.