开发者

Custom Menu visible to one document in Excel

开发者 https://www.devze.com 2023-01-30 09:48 出处:网络
I have created customized menu and toolbar in MS Exc开发者_开发问答el. I wanted to show this menu and toolbar to specific document only. When I open any other xls file, it shows that menu and toolbar.

I have created customized menu and toolbar in MS Exc开发者_开发问答el. I wanted to show this menu and toolbar to specific document only. When I open any other xls file, it shows that menu and toolbar.

MS Excel 2003

How to do that using vba-excel macro or any other way to do that?

If you need more information, please ask me.

Thanks :)


OK - so this website will help you: http://www.ozgrid.com/VBA/custom-menus.htm

It actually works in Excel 2007 also, but adds the menu under the Add-Ins tab.

You basically need to access the code for ThisWorkbook in the VBA application. From there, you can modify the Application.CommandBars object to do what you need.

0

精彩评论

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