Deleting Sheet Message

G

Guest

Is there a way NOT to get the "Data may exist in the sheet(s) selection for
deletion. To permanently delete the data, press delete" message when deleting
a worksheet?

I put the code "Application.CutCopyMode = False", but it does not work.

Thanks
 
C

Chip Pearson

Lucia,

Try

Application.DisplayAlerts = False
Sheets("Whatever").Delete
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)
 

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

Deleting a sheet during macro 1
Deleting a sheet with VBA 2
Data may exist in the sheet(s) message 5
Avoid Window Message while deleting a sheet 4
Delete chart without being prompted? 2
Disable Worksheet Delete Warning 1
remove Worksheet using Sh.Delete without prompt 3
Delete Worksheets 4

Top