Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Override "Send this Sheet"
Hi,
I need to capture the "Send this sheet" button click event to override its functionality. "Send this Sheet" can be found on opening File - Send To - Mail Recepient. It can also be found using ActiveWorkbook.EnvelopeVisible = True in VBA. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Override "Send this Sheet"
You can assign a macro to its onaction property or replace the button. You
can't override a method of the Workbook in VBA in anyway I can think of. http://support.microsoft.com/default...b;en-us;830502 How to customize menus and menu bars in Excel http://support.microsoft.com/default...b;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. -- Regards, Tom Ogilvy "Priya" wrote in message ... Hi, I need to capture the "Send this sheet" button click event to override its functionality. "Send this Sheet" can be found on opening File - Send To - Mail Recepient. It can also be found using ActiveWorkbook.EnvelopeVisible = True in VBA. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
HOW DO I OVERRIDE THE "COPYRIGHT" SYMBOL TO INSERT (C)? | Excel Discussion (Misc queries) | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
How do I cancel the "Send this Sheet" option? | Excel Discussion (Misc queries) | |||
How to override "Too Many Cell Formats" error comment. | New Users to Excel |