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