Macro delete + confirm deletion

I have created a macro to auto delete a tab when a certain action is carried out. However a msg appears asking to confirm the tab deletion. Is there anyway to stop this msg appearing as i do not want the user to be able to select No.

thanks

Hi,

thanks....but i'm getting a run-time error '423' - object required??

I using the following code;

Please Login or Register  to view this content.

any ideas where i've gone wrong