Is there a way to set sheet view using VBA code?
Is there a way to set sheet view using VBA code?
Hi Bjotr
If you had a shared workbook with a sheet called "MyResults" say, and created a view called "Meeting view" for that, VBA could display that sheet view with this code (within a standard module sub) :
With Worksheets("MyResults")
.Activate
.NamedSheetViews.GetItem("Meeting View").Activate
End With
You can change the bits in bold above to suit your file.
Hope this helps.