开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜