quit without saving option

I have a program that sits on a network when the program closes it
always gives the user the option to save the file, can i stop this from
happening to that when the close button is selected on my userform the
file just shuts straight down

thanks

ActiveWorkbook.Close SaveChanges:=False

or, you can try setting the Saved property to True

ActiveWorkbook.Saved = True

--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> I have a program that sits on a network when the program closes it
> always gives the user the option to save the file, can i stop this from
> happening to that when the close button is selected on my userform the
> file just shuts straight down
>
> thanks
>