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

Disable Outlook AutoCorrect with GPO 0
Can not select task type 0
ASK Field Formatting 1
Need Help with Macro Security 1
To protect user's privacy 1
Display weeks from a Milestone 0
Variables in a Popup prompt 5
Pop up window?? 5

Top