Macro to cancel Startup Messages

I have a Macro that opens numerous excel files.

What code do I require to cancel the startup message?

ie. The message that displays "Disable / Enable Macros" (security setting cannot be changed, so message is always displayed).

Plus I then have some startup message boxes which I manually click OK to continue, but how do I cancel this messages using VBA Code?

Anyone able to assist?

I have just started to frequent this forum, and this is my first post. Still, royUK's reply seems unnecessarily blunt and unhelpfull. This sort of question must be one of the most frequently asked by budding VBA programmers and I'm surprises how little information I found when I searched the forums for an answer.

IanBrown,

If the security settings in Excel are set to High, I don't know if there is a way to run your code without the warning or without a digital certificate. I think digital certificates can be purchased, but this is not usually an option for hobbyists or smaller VBA projects. However, I think if the security settings are set to Medium or Low, you can create your own Digital Signature using a utility which comes with your Office CD called "selfcert.exe". You may or may not have installed it already, search for "selfcert.exe" on your computer. Do a Google Search or search your Excel help file for "Digital signature" for more information.

Basically, the selfcert.exe program allows you to create your own certificate to digitall sign your VBA projects. The first time a user opens an excel file that contains your code and your signature, there is a way (Open file -> View Certificate -> Install Certificate -> Reopen file) to install the certificate. Once installed, the security warning will no longer be displayed when he opens documents containing the code that you have signed. It's important that you sign all of your projects with the same certificate so that users don't have to repeatedly install different certificates.

Good luck!

Wtf!? I just spent a considerable amount of time composing a concise and helpfull reply. A very legitimate reply to a very legitimate question. Was it sensored and removed from the forum?

Please also clarify what you mean by

If you want to complain about the rules, then direct them to VBA Noob who dreamt up the rules and posted them as a registered user set up especially (and only) for this purpose (X-Cell, who'll you see has only 5 posts to his credit). Anyone feel free to send him a PM complaining abut the rules. You'll probably find most mods don't agree with them either (two notwithstanding).

VBA Noob dreamt up the rules? Who is VBA Noob? Who is X-cell and what does he have to do with this? Are you one of the moderators that agrees with the rules?

I will check the rules when I have time, but right now, I cannot fathom why a post explaining how to facilitate the distribution and use of VBA projects should be removed. Without circumventing this warning by using the utility that is provided by Microsoft (which I will not name for fear of being sensored again), the resulting VBA projects are so much more annoying, and that entierly defies their purpose.

dominicb,
Thank you for your reply. I understand what you meant now and I agree with you. Also, I thought that you had removed my previous post from the forum, but now I can see that it is there. I'm not sure if you removed and put it back or if you never touched it and I'm just the real Noob around here. Regardless, it's all good now.

royUK,
Glad to hear you answer 100s of questions. I don't expect a novel, I just felt your reply was too short to be of any value to anyone. I was under the impression that IanBrown was a relatively new coder and hadn't heard of selfcert.exe. I had the exact same experience as he did, when I started making VBA projects and I wouldn't have bothered to make any of them had I not discovered selfcert.exe.

The set-up we have is that everyone's settings are on Medium and everyone has accepted my certificate. This means that I can create new VBA code or edit old code, and the users will not be bothered by any annoying warnings at all. They open the excel file and the code runs without problem. I just put my security level to High and the code still run without warnings. Excel XP version.

IanBrown should have received all the answers he needs by now.

Take care everyone and happy coding.

P.S. Can't make up my mind about all the smiley icons around this reply-box. No I can, there are way too many for this type of forum.

Many thanks for your assistance thus far.

Perhaps a simpler problem is that I also have numerous MsgBox messages displayed when I open my excel file (ie. located in Workbook_open).

These messages are useful to the individual users, but when I create a macro to open, say 50, of these excel files (to collate all the data) I need to click "OK" continually!

Is there a command to automatically cancel these message boxes?

Regards.....