I'm not a proper coder, maybe someone else will chip in. However, I couldn't
find anything on this, so if it *can't* be done, I'd suggest checking for a
view *condition*. So if View1 involved column C being hidden, something
like:
If Sheets("Sheet1").Columns(3).Hidden = True Then
MsgBox "You're in View1."
'do stuff
Else
MsgBox "You're in View2."
'do other stuff
End If
HTH,
Andy
"Bart" wrote in message
...
Hello
I have to create a piece of code wich makes a few buttons visible or in
visible depending of te active customview that is selected on a sheet.It
has
to be something like this:
Private Sub Worksheet_Activate()
If (ACTIVECUSTOMVIEW = view1) then
CommandButton1.Visible = False
End If
If (ACTIVECUSTOMVIEW = view2) then
CommandButton1.Visible = True
End If
End Sub
Thanks in advance...
|