开发者

Vba button to activate sheet

开发者 https://www.devze.com 2023-02-06 04:33 出处:网络
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开发者

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

精彩评论

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

关注公众号