Deleting a sheet without the "are you sure" massage 1

[IanStrange]

Hi
I am writting quite a big spread sheet and at one point it creates a new sheet does some stuff then deletes the sheet. But the problem I have is the users of this she are very dim and can not cope with clicking the yes button. So I was wondering if there is a way to delete the sheet without them having to click the yes button.

No man is an island but 6 tied together make quite a good raft.

 

[dyarwood]

Try

Application.DisplayAlerts := False
Sheet(name).Delete
Application.DisplayAlerts := True

dyarwood

 

[IanStrange]

That is perfect except for the : befor the =
Thanks you

No man is an island but 6 tied together make quite a good raft.