hide and unhide a column with PASSWORD

[YOUSSEFam]

Hello Team

I have data in all my sheet and i want hide the data exist in column B this data can be display pay password, so just who have the password can see data in colum B,
for data in rest of column can be see and modify by all

thanks for your helping .

[wk9128]

pls try this code

Protect

Please Login or Register  to view this content.

UNProtect

Please Login or Register  to view this content.

[TMS]

Please note that Excel is not a secure environment. Just because column B is locked and hidden, it doesn't mean that people can't easily view the contents (and the formulae).

[YOUSSEFam]

thanks for your answer 😊

this macro is hide and unhide colomn B without demand of
password, also i want let others users access to modify
all things exist in Excel not jsut editing,
my
objective that users can't just see or modify data of colomn B and may do all changes in excel


thanks

[wk9128]

ANS#4

pls try this code
Protect

Please Login or Register  to view this content.

UNProtect

Please Login or Register  to view this content.

[YOUSSEFam]

I highly i appreciate your help, i develop little bit this code as you can find here, me still one more thing that to permit to all users to hide and unhide all columns except column B

password = fes

------------------------------------
Sub ProtectColumnB()
' Protect the sheet
ActiveSheet.Protect Password:="fes", UserInterfaceOnly:=True, AllowFormattingCells:=True, AllowInsertingRows:=True
' Set column B as hidden and locked
Columns("B").Hidden = True
Range("A:XFD").Locked = False
Range("B:B").Locked = True
End Sub

--------------------------------
thanks in advance