View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bart Bart is offline
external usenet poster
 
Posts: 21
Default 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...