Let me restate my issue as follows:
I create a button in excel called save. The code behind
the save button is to save the file as MyFile to
U:\corporate. I want the user to save the file to
U:\corporate by press my save button only. They will not
be allowed to use File menu save as button to save the
file to U:\corporate. How can I turn of the Save AS
function from File menu for U:\corporate while in the
meantime the user is allow the save the change they make
on the worksheet but not save it as a new file name to
U:\corporate.
Thank you.
-----Original Message-----
Susie,

Your posts to the same questioned are getting fractured.
Try to keep it all
together by using the Reply Group instead of creating a
New Post.

I am lost as to what you have read and what you are
asking.

thanks

steve

"susie" wrote in message
...
I know I can set up the folder as readonly. However I
can
not set it up because I have a function button should be
able to allow use to click on it and save the file to
the
Is there anyway to allow my code running to save the
file
to U:\myfolder but disallow the user using File- Save as
function to save it to U:\myfolder?

Thank you.


.