ActiveWorkbook.Close SaveChanges:=False

or, you can try setting the Saved property to True

ActiveWorkbook.Saved = True

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
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