Need help on pop-up alerts

[romandotcom]

Hi,

I need 2 more help on Macro Code. I

1. While a specific macro is working in a specific tab named “Current Year”, it creates another tab to rough few items (tab name: “Name”) and it bring the final information from “Name” tab to “Current Year” tab. After that it deletes the “Name” tab that macro created for rough working. But the issue is, it shows a pop-up alert that I really want to delete this tab permanently or not. I have added the below code to remove this alert but it did not remove. I mean it continues to show the alert. Would you please review my code?

Please Login or Register  to view this content.

2. In the same macro, in the rough work, there is a process called “Text to column”. While macro works on this part, it shows another pop-up alert that it will replace some data. I have to click “OK” to proceed. Is there any code to disable this alert and it will work considering it is “OK”?

I have attached both alerts.

Thank You
Roman

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[romandotcom]

Hello!

I am very sorry. It will not happen again. I have corrected the request.

Thank You
Roman

[AliGW]

Thanks, Roman.

[PaulSP8]

You need to switch the Alerts off before doing the action

Please Login or Register  to view this content.

[romandotcom]

Thank You. Its working. Would you please see my 2nd query too?

Thank You
Roman

[romandotcom]

I could resolve my second query. I put the below code before the text to column code starts.

Please Login or Register  to view this content.

[PaulSP8]

No problem - Glad I could help.