columns
hi,
i have the following:
If Sheets("detail").Range("IV1").Value = "admin" Then
Sheets("detail").Select
Columns("A").Visible = True
Else
Sheets("detail").Select
Columns("G").Visible = False
End If
but i am getting an "object does not support this method" error message. why?
thanks in advance,
geebee
"Jim Thomlinson" wrote:
One way might be to remove the row and column headers. Tools - Options -
View - uncheck Row & Column Headers.
This will make it distinctly more difficult to unhide the columns without
having to resort to some form of protection.
--
HTH...
Jim Thomlinson
"geebee" wrote:
hi,
i want to be able to hide and unhide columns in excel depending upon a value
selected and then veryfying whether or not a value entered is correct. but
the only disadvantage of this is that any user who does not enter the value
correctly can just go to the sheet and select column -- unhide. i want to
prevent this from happening.
what is the best way to handle this?
thanks in advance,
geebee
|