I have two custom views that I'd like to toggle between using a ribbon button.
When the workbook is opened I need the custom view to be JP.
When the button on the ribbon is pressed I need the custom view to be JPLOG.
Pressing the ribbon button again would switch back to JP.
Something like this?:
When the workbook is opened I need the custom view to be JP.
When the button on the ribbon is pressed I need the custom view to be JPLOG.
Pressing the ribbon button again would switch back to JP.
Something like this?:
VBA Code:
Sub LogShow()
If ActiveWorkbook.CustomViews("JPLOG") = True Then
ActiveWorkbook.CustomViews ("JP")
Else
ActiveWorkbook.CustomViews ("JPLOG")
End If
End Sub