Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() You can record a macro that deletes the email options from the File menu when you open the file. The help function includes these instructions for manually customizing menus: *DELETE A COMMAND FROM A MENU* On the Tools menu, click Customize. The Customize dialog box must remain open; however, you might need to move it out of your way. Click the menu that contains the command you want to delete. Drag the command you want to delete off the menu. Simply Record a macro while performing the above, and save it as : -Private Sub Workbook_Open()- If you want to restore these menu functions after users close the workbook, simply record a macro while dragging the deleted items from the Customize dialog box back to the File menu, and save that macro as -Private Sub Workbook_BeforeClose()- -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=542725 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete a workbook while in a macro | Excel Worksheet Functions | |||
Address of workbook in a macro | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
How turn off macro security question for workbook with no marcos? | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) |