Collaboration: Automatically start-up with Sheet View option

[Ferdib]

Hello everyone,

I've created an Excel file for orders for different countries.
Each country has multiple people working on the file.
There are about 10 people working in the file at the same time continuously.
A lot of filtering on country/product/date/status/etc needs to be done by each individual.
Even though the instructions are clear, there is always someone filtering the columns for everyone...

So my question is; is there a way, with VBA for example, to open this workbook (sheet) in Sheet View (preferably Temporary View) automatically?
The workbook is stored on Sharepoint.

Thanks in advance!

 

[Ferdib]

Posting solution for anyone who might need it in the future:

Private Sub Workbook_open()
Application.CommandBars.ExecuteMso ("NewSheetView")
End Sub

This will open the workbook in a Temporary View (View > Sheet View).