How to turn off a warning messages and hide all activities from the user

[akabraha]

Hello - Good morning.

1. I have a macro which deletes a sheet if it's a duplicate. I get the following warning -

"Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete"

Q: How to turn off this warning message?


2. When I run the macro it steps through diffetent sheets and do many data extraction and manipulation, wondering if I can hide all these activities from the user?

Thanks in advance for the help.

Anil

[BigBas]

1.

Please Login or Register  to view this content.

2. I'm not sure how to do this.

[Kaak]

Please Login or Register  to view this content.

[akabraha]

It worked - Thanks a lot BigBas and Kaak - you guys are so quick and helpful.

[photosplus]

Hello,
I get a similar message everytime I press a hyperlink to start an application. The message warns: "Some files can contain viruses or be harmful. It is important to be certain that this file is from a trustworthy source. Would you like to open file?"
I press OK and link activates but this is an extra keystroke that I would love to eliminate.
If solution requires code, please explain how I do this as I am not familar with registry entries.

Thanks,
Photosplus