Detecting active customview
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...
|