Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro
 
Posts: n/a
Default Using macro to stop user from emailing workbook


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete a workbook while in a macro jthurnwps Excel Worksheet Functions 1 March 10th 06 09:22 PM
Address of workbook in a macro frendabrenda1 Excel Discussion (Misc queries) 8 March 8th 06 06:01 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 15th 05 11:13 PM
How turn off macro security question for workbook with no marcos? Dewy Cheatum & Howe Excel Discussion (Misc queries) 2 December 9th 05 10:14 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"