SAVE AS menu option

[Mircea Pleteriu]

Hi,

How to disable the File's Save As menu option?

Thanks,
Mircea

 

[keepITcool]

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 :

 

[Mircea Pleteriu]

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?

 

[Bob Phillips]

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)

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?

Hi,

How to disable the File's Save As menu option?

Thanks,
Mircea