Disabling SaveAs
 

Hi there!

i am having trouble coming up with a method to disabling or removing
the save as function in the File menu command. Basically i do not want
users to copy the file to any locations except the approved ones.

thanks a lot
:)


--
rbeatson2002
------------------------------------------------------------------------
rbeatson2002's Profile: http://www.excelforum.com/member.php...o&userid=34554
View this thread: http://www.excelforum.com/showthread...hreadid=543180

Disabling SaveAs
 

If you don't already have an 'AutoExec' macro then create a new one and add
the following line, or of course just add it to your existing AutoExec macro
if you have one.

commandbars(''Worksheet Menu Bar'').Controls(''Window'').Controls("Save
As...").Enabled=False


You will of course need to re-activate it when you exit your worksheet.

HTH

Neil
www.nwarwick.co.uk

"rbeatson2002" wrote:


Hi there!

i am having trouble coming up with a method to disabling or removing
the save as function in the File menu command. Basically i do not want
users to copy the file to any locations except the approved ones.

thanks a lot
:)


--
rbeatson2002
------------------------------------------------------------------------
rbeatson2002's Profile: http://www.excelforum.com/member.php...o&userid=34554
View this thread: http://www.excelforum.com/showthread...hreadid=543180

Disabling SaveAs
 

Does this do what you need ?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI = True Then
MsgBox "No SaveAs"
Cancel = True
End If
End Sub

NickHK

"rbeatson2002"
wrote in message
news:rbeatson2002.27zmrm_1147929901.5639@excelforu m-nospam.com...

Hi there!

i am having trouble coming up with a method to disabling or removing
the save as function in the File menu command. Basically i do not want
users to copy the file to any locations except the approved ones.

thanks a lot
:)


--
rbeatson2002
------------------------------------------------------------------------
rbeatson2002's Profile:
http://www.excelforum.com/member.php...o&userid=34554
View this thread: http://www.excelforum.com/showthread...hreadid=543180

Disabling SaveAs
 

Thanks Nick and Neal this helped heaps!!!


--
rbeatson2002
------------------------------------------------------------------------
rbeatson2002's Profile: http://www.excelforum.com/member.php...o&userid=34554
View this thread: http://www.excelforum.com/showthread...hreadid=543180