Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
At is simplest, you could use something like the following to hide/unhide
column "E". Sub HideUnhideWithPassword() Dim PW As String PW = InputBox("Enter a password:") If StrComp(PW, "CorrectPassword", vbBinaryCompare) = 0 Then With ThisWorkbook.Worksheets("Sheet1").Columns("E") .Hidden = Not .Hidden End With Else MsgBox "Invalid Password" End If End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "shapiro" wrote in message ... Does anyone know a VBA code to hide a coumn using a password? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide a column using a password | Excel Discussion (Misc queries) | |||
hide column with password | Excel Discussion (Misc queries) | |||
how to hide raws and use password | Excel Worksheet Functions | |||
how to hide raws and use password | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |