PDA

View Full Version : Delete Excel sheet without prompt



StockyPM
06-18-2009, 05:48 PM
Hi,

I've written a procedure to delete a large number of sheets from an Excel workbook (Excel 2002) and am wondering if anyone can help me with code that will prevent the prompt comping up "Data may exist.. To permanently delete the Data, press Delete?"

I want to avoid the user having to sit there pressing Delete heaps of times.

Thanks!

p45cal
06-18-2009, 05:59 PM
check out Application.DisplayAlerts