Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there!
I have created a button that opens an excel file (Actions -> Open URL).
It works but... The things is that there is several sheets in my file and I want to set only one that will always be opened as first. How can I specify a default sheet?
All the best,
Angelika
I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.
Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.
- Marcus
I think it's not possible - at least not with this approach. If you call a vbs-macro with your button which opens the Excel it could afterwards switch to your defined sheet.
Another method may be to implement an OnOpen macro within the Excel which queries the accessing user and switched then to your wanted sheet.
- Marcus
Thank you for the hints.