Vba button to activate sheet
I am trying to write the callback for a button on the backstage view.
I want to select a certain worksheet and show it to the user. I thought aboutsheet("sheetName").activate
. This is select开发者_开发知识库ing the sheet sheetName, but Excel stays in backstage view.
My question is how can I actually show the sheet, i.e. make it visible? I need to be able to hide backstage view and go to "document view"...
Regards
Add the attribute isDefinitive="true" to the ribbon backstage button xml. It will close the backstage view after the button is clicked and switch back to the main view with the previous tab selected.
精彩评论