Disabling SaveAs

[rbeatson2002]

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

[Neil]

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
>
>

[NickHK]

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" <rbeatson2002.27zmrm_1147929901.5639@excelforum-nospam.com>
wrote in message
news:rbeatson2002.27zmrm_1147929901.5639@excelforum-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
>

[rbeatson2002]

Thanks Nick and Neal this helped heaps!!!