Determining what current custom view is

[KC Cat]

Hello to all,

I have the following code that is working very nicely.

Sub View_Show_Budgeting()

    Application.ScreenUpdating = False
    
    Dim rowVar As Integer
    rowVar = ActiveCell.Row
    
    If Range("ChangeOrderStatus") = 0 Then
        ActiveWorkbook.CustomViews("Budgeting").Show
        Range("CurrentViewStatus") = "View = Budgeting"
    Else
        ActiveWorkbook.CustomViews("Budgeting w/COs").Show
        Range("CurrentViewStatus") = "View = Budgeting w/COs"
    End If
    
    Application.ScreenUpdating = True

    Cells(rowVar, 1).Select

End Sub

Now, I have created another subroutine that I need to first establish which custom view is currently active. Then, this new subroutine will perform its actions, and will then need to return the view back to where it was. Please note, for what it's worth, that my custom view names can include spaces and the "/" character.

I'm not sure what function to use, or how, to "collect" this active view information.

Any help will be greatly appreciated!