Take over menus

[O. Sorensen]

Hi,
In Word it is possible to take over the menus by adding a subrutine
FileNew, FileOpen or similar.
However, I cannot find anything like this in Excel.

Does anyone have any suggestions on how to accomplice this?

I know that I can manually use "Customize..." and assign a macro to a
menu, but can this be done automatically at startup?

I need to assign new macros to both FileOpen and FileSaveAs to 100+
users, so I don't want to run around to each machine and do the
customization manually ;-)

Best regards
Ole Sorensen

 

[Tom Ogilvy]

No. You have to replace the existing commandbar button or assign it to your
macro.

 

[Fredrik Wahlgren]

Hi,
In Word it is possible to take over the menus by adding a subrutine
FileNew, FileOpen or similar.
However, I cannot find anything like this in Excel.

Does anyone have any suggestions on how to accomplice this?

I know that I can manually use "Customize..." and assign a macro to a
menu, but can this be done automatically at startup?

I need to assign new macros to both FileOpen and FileSaveAs to 100+
users, so I don't want to run around to each machine and do the
customization manually ;-)

Best regards
Ole Sorensen

You can create your own menus. Why would you want to actually take over a
menu?

http://msdn.microsoft.com/library/d...en-us/odc_vsto2003_ta/html/odc_VSTCommBar.asp

/Fredrik

 

[Tom Ogilvy]

If the OP isn't working in Visual Basic .Net or C# .Net then

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

 

[Ole Sorensen]

Hi Tom and Fredrik,

Thanks, - I'll look into this.
I have writting some VB.NET classes that handles some extra features in the
saving-process (essentially like a document handling-system), which I want
to impose on all users in my company. Therefore, I need to re-program their
SaveAs to call my function before actually saving.

BR Ole Sørensen,