Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS menu option
Hi,
How to disable the File's Save As menu option? Thanks, Mircea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS menu option
That would disable any possibility for users to save their work under different names. If you want to prevent users saving a particular workbook under another name then write an eventhandler for that workbook. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI Then MsgBox "That's a nono" Cancel = True End If End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Mircea Pleteriu wrote : Hi, How to disable the File's Save As menu option? Thanks, Mircea |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS menu option
his.excelApp.CommandBars["File"].Controls[<NUMBER].Enabled = false;
I know that each control (menu option) has a number assign to it. Where from can I get this map? "Mircea Pleteriu" wrote in message ... Hi, How to disable the File's Save As menu option? Thanks, Mircea |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS menu option
see response to other post. But KeepItCool's warning is a good one, you
should take note. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... his.excelApp.CommandBars["File"].Controls[<NUMBER].Enabled = false; I know that each control (menu option) has a number assign to it. Where from can I get this map? "Mircea Pleteriu" wrote in message ... Hi, How to disable the File's Save As menu option? Thanks, Mircea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Menu doesn't Display | Excel Discussion (Misc queries) | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
get xml option in data menu | Excel Discussion (Misc queries) | |||
add option to drop down menu | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |