Suppressing or trapping system msgs in excel 2k
 

I've automated a timesheet process doing data collection via Access 2k,
building
an excel 2k workbook via VBA containing individual timesheets which are then
printed.
I've used a .xlt template with one worksheet which I duplicate and rename
for each employee.

At the end I delete the templete worksheet, which pops up a Excel system msg
'the selected sheet(s) will be permanently deleted' with cmd btns 'ok or
cancel'...

The VB 'on error' keyword isn't being triggered as I have tried 'on error
resume next'
or forcing an error handler and 'displayalerts = false' without success.

Is there a way to redirect/control this system msg as it is rather confusing
to the end user.

Any suggestion would be greatly appreciated!

Thanks in advance. Doug

Suppressing or trapping system msgs in excel 2k
 

'displayalerts = false' must be changed

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

Gord Dibben Excel MVP

On Tue, 16 Nov 2004 22:56:44 GMT, "mike" wrote:

I've automated a timesheet process doing data collection via Access 2k,
building
an excel 2k workbook via VBA containing individual timesheets which are then
printed.
I've used a .xlt template with one worksheet which I duplicate and rename
for each employee.

At the end I delete the templete worksheet, which pops up a Excel system msg
'the selected sheet(s) will be permanently deleted' with cmd btns 'ok or
cancel'...

The VB 'on error' keyword isn't being triggered as I have tried 'on error
resume next'
or forcing an error handler and 'displayalerts = false' without success.

Is there a way to redirect/control this system msg as it is rather confusing
to the end user.

Any suggestion would be greatly appreciated!

Thanks in advance. Doug