Macro to Click on Popup message option "Delete"

[Chintu Raju]

Hi,

I have a macro which needs to delete a particular worksheet. But a message pops up asking for confirmation of the deletion of the worksheet. I tried recording by clicking on the "Delete" option, but this part doesn't get recorded.

Can u let me know what is the code for clicking on the "Delete" option on this message box?

Thanks

[jameslou]

This can be one using VBA.

[mudraker]

Add this command before the delete commad

Please Login or Register  to view this content.

Add this command after the delete command

Please Login or Register  to view this content.

[Chintu Raju]

Works perfect

Thanks a lot !