Thread: Take over menus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Take over menus

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

--
Regards,
Tom Ogilvy

"O. Sorensen" wrote in message
om...
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