Disable Prompts

M

MatthewT

I want to delete a worksheet as part of a VBA project. How do I disabl
the prompt asking if you are sure you want to delete it? I want t
take away this control from the user just within the project
 
A

Alan

Try

Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True

Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save without Macros without prompting 1
To protect user's privacy 1
Match Found - Delete 2
Disable Clear DContents command in excel - vba code?? 3
Generate Subtotal Summary from Sheet1 into Sheet2 16
How to bypass password when pasting FROM a protected workbook 3
How to disable close button in userform? 2
Excel prompts for VBA password when opening 5

Top