deleting a worksheet (no prompting) and closing workbook

[pavlos]

hey all
first,

what is the code I use when the [x] button is pushed.
is it like private sub form_closed??? - dont think it is

when the user puses the [x] (top right hand corner. I want to code an action.
is this possible?


i know you a form is opened the code is
form_activate

2nd
when i use the following command
Sheets("Temp").Delete

it will prompt me if i am sure i want to delete. I do not want to be prompted.

cheers

[JBeaucaire]

Application.DisplayAlerts = False
Sheets("Temp").Delete

[pavlos]

thanks

i only want it to not display alerts if clicking the x button
any idea?

[davesexcel]

Are you referring to a UserForm?
Or when closing a Workbook?

[pavlos]

user form
the [x] button on the user form.