SAVE AS menu option
 

Hi,

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

Thanks,
Mircea

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

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

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