Delete an Excel page 1

[MrMajik]

I am using VisualBasic and have the code delete a worksheet called Temp when done with it. Here is how I am doing it:

Sheets("Temp&quot.Select
ActiveWindow.SelectedSheets.Delete

This always asks the user if they want to delete it. The answer is always Yes. Is there a way to delete a worksheet without the user getting involved?

Thank you.

 

[Dreamboat]

Application.DisplayAlerts = False

At the end of your code put:

Application.DisplayAlerts = True

I think.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[MrMajik]

Dreamboat; That's a good BINGO! Lets give a star for that

Thank you very much.

MrMajik

 

[KenWright]

Just as an addendum you can often also use a similar logic to speed up your code. If your code would involve a lot of jumping about between ranges or spreadsheets, then this can impact speed.

Application.ScreenUpdating = False

at the beginning of your code, and

Application.ScreenUpdating = True

at the end is similar to the old commands you may remember of Echo On and Echo Off. It will stop the sceren showing what is going on, and only at the end of the code will it finally update the screen.

Regards
Ken...............

 

[MrMajik]

KenWright; You must be reading my mind! I was wondering if your suggestion was possible.

Thank you for sharing.

MrMajik

 

[Loomah]

MrMajik
Just another little addition for information. Code can be speeded up by not selecting objects unless absolutely necessary. In the case you have here

Worksheets("Test").Delete

will do the same job without selecting the sheet then referring to it throught the active window object.

;-)

If a man says something and there are no women there to hear him, is he still wrong?