Excel hide column and protect

%3CLINGO-SUB%20id%3D%22lingo-sub-1849721%22%20slang%3D%22en-US%22%3EExcel%20hide%20column%20and%20protect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849721%22%20slang%3D%22en-US%22%3E%3CP%3EI%20password%20protected%20an%20Excel%20worksheet%20so%20certain%20columns%20were%20hidden%20and%20many%20fields%20were%20locked.%20I%20emailed%20this%20to%20my%20staff%20and%20they%20figured%20out%20that%20they%20could%20use%20%22save%20as%22%20to%20save%20a%20new%20document%20and%20view%20the%20hidden%20columns%20and%20make%20changes%20to%20locked%20fields.%20How%20can%20I%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1849721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850069%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20hide%20column%20and%20protect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850069%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F856109%22%20target%3D%22_blank%22%3E%40JeanMP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EWith%20your%20permission%2C%20knowing%20the%20exact%20Excel%20version%20(e.g.%20365%20Home%20-%20not%20just%20365)%20and%20the%20exact%20operating%20system%20(e.g.%20Win10%20(20H2))%20would%20be%20an%20advantage%20for%20everyone.%20Of%20course%2C%20it%20would%20help%20everyone%20if%20you%20uploaded%20an%20Excel%20file%20(with%20no%20sensitive%20data).%3CBR%20%2F%3EWith%20this%20you%20could%20see%20the%20error%20directly%20and%20fix%20it.%20No%20picture%20please%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20Excel%20certainly%20does%20not%2C%20on%20the%20contrary%20in%20some%20cases.%3CBR%20%2F%3EAll%20of%20this%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20your%20problem%2C%20I%20can%20recommend%20that%20you%20click%20the%20%22Protect%20worksheet%20and%20contents%20of%20locked%20cells%22%20box%20when%20locking%20the%20worksheet%20when%20locking%20the%20worksheet.%20If%20you%20have%20locked%20the%20worksheet%20with%20VBA%2C%20I%20recommend%20locking%20the%20VBA%20project.%3CBR%20%2F%3EBut%20as%20I%20said%2C%20without%20knowing%20which%20version%20of%20Excel%20it%20is%20and%20which%20digital%20environment%20as%20far%20as%20the%20operating%20system%20or%20network%20is%20concerned%2C%20I%20cannot%20offer%20you%20a%20specific%20proposal%20for%20a%20solution.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I password protected an Excel worksheet so certain columns were hidden and many fields were locked. I emailed this to my staff and they figured out that they could use "save as" to save a new document and view the hidden columns and make changes to locked fields. How can I

1 Reply
Highlighted

@JeanMP 

With your permission, knowing the exact Excel version (e.g. 365 Home - not just 365) and the exact operating system (e.g. Win10 (20H2)) would be an advantage for everyone. Of course, it would help everyone if you uploaded an Excel file (with no sensitive data).
With this you could see the error directly and fix it. No picture please, even if it is said that a picture can say a thousand words, Excel certainly does not, on the contrary in some cases.
All of this would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

For your problem, I can recommend that you click the "Protect worksheet and contents of locked cells" box when locking the worksheet when locking the worksheet. If you have locked the worksheet with VBA, I recommend locking the VBA project.
But as I said, without knowing which version of Excel it is and which digital environment as far as the operating system or network is concerned, I cannot offer you a specific proposal for a solution.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)