Re: [DUG-OFFTOPIC]: Excel Macro question

[Magnus Rasmussen]

REmove me from your list ----- Original Message ----- From: Mike Osborne To: Multiple recipients of list offtopic Sent: Tuesday, March 27, 2001 8:20 AM Subject: Re: [DUG-OFFTOPIC]: Excel Macro question Worked like a charm - Thanks. ----- Original Message ----- From: Mason, John To: Multiple recipients of list offtopic Sent: Tuesday, March 27, 2001 5:06 PM Subject: Re: [DUG-OFFTOPIC]: Excel Macro question I assume this is a macro you've written. If so, then insert the line     Application.displayalerts=false before the command to delete the worksheet, and     Application.displayalerts=true after the command to restore system alerts.   Mike Osborne wrote: Completely off topic. I have a macro that deletes a worksheet as part of its processing. It presents a dialog box to confirm the permanent deletion of the worksheet. How can I set up an automatic reply or prevent that dialog box from showing? When I link the macro to the WorkBook Open event it doesn't present the dialog box or delete the worksheet. Any Excel experts out there who can point me in the right direction? TIAMike -- John Mason Sinclair Knight Merz Limited     --------------------------------------------------------------------------- New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz