[RESOLVED x 2] Macro enabling in Excel

[krtxmrtz]

I have a similar question to this one.
I want to enable the macros without being prompted when I open a specific Excel spreadsheet. I know I can disable this by checking the checkbox or in the "general" tab under options. But I want to be asked about macro-enabling when I open any other Excel file. It is possible to change this setting for individual files?

[RobDog888]

You can do it for your system only but you may loose the prompt for all. You need to create a Digital Certificate and sign your Excel VBA code with it. Then In your security settings set it to high (only signed macros will run).

I am not sure if it will not prompt you if you have it set to medium. Test it out and let me know. I have a codebank thread on creating private Digital Certificales and how to make them Trusted. I'll post the link.

[RobDog888]

Here it is. It has step by step instructions and all.

http://www.vbforums.com/showthread.php?t=285212

[c03cg]

so if you were to create a digital certificate for a program that was to run from a network drive, any of the machines logging onto the network and opening the file could do so with the security set to 'High'?

[RobDog888]

No, you need to make DS' on each workstation. A private DS is not for any type of Public production of a program as a person could modify the app and have it be malicious and it would be tracked back to the system that created the DS. For public production apps you need a Public DS like the ones from Verisign at $400 a year.

[krtxmrtz]

Here it is. It has step by step instructions and all.

http://www.vbforums.com/showthread.php?t=285212

It works nicely, exactly what I need.

[krtxmrtz]

Here it is. It has step by step instructions and all.

http://www.vbforums.com/showthread.php?t=285212

By the way... can you create the trusted digital certificate for Office < 2003 as well?

[RobDog888]

Yes, as long as you have the SELFCERT.EXE file in the desired version. I know Office 2002 (XP) has it but I am not 100% sure 20000 has it.


Hmm, just thinking if you create a Cert in one Office version and upgrade your Office to another would you be able to still sign new projects with the cert or do you need to create another in the new version?

[krtxmrtz]

Yes, as long as you have the SELFCERT.EXE file in the desired version. I know Office 2002 (XP) has it but I am not 100% sure 20000 has it.


Hmm, just thinking if you create a Cert in one Office version and upgrade your Office to another would you be able to still sign new projects with the cert or do you need to create another in the new version?

At any rate I guess I can't just copy the selfcert file I have in my WinXP + Office 2003 to a Win98/Office 97 computer and expect it to work... But what the heck, I'm going to try just in case.

[RobDog888]

You could try running the selfcert on your win98 system and see if it generates a cert. If it does then sign your project and test it out. Im not sure if 97 supporst signing of projects.

[krtxmrtz]

You could try running the selfcert on your win98 system and see if it generates a cert. If it does then sign your project and test it out. Im not sure if 97 supporst signing of projects.

Well, I tried to run selfcert.exe under Win98 but it complained about makecert.exe missing in the same directory, so I'll have to copy this one from the home computer and try again tomorrow.

[krtxmrtz]

By the way!!!... is there any means to protect the vba code within the Word document? I'm trying to prevent people from copying the document, printing it and screen shooting it... I'm almost done but I still must find the way to disable access to the vba code. How come I didn't think of this?

[cssriraman]

By the way!!!... is there any means to protect the vba code within the Word document? I'm trying to prevent people from copying the document, printing it and screen shooting it... I'm almost done but I still must find the way to disable access to the vba code. How come I didn't think of this?

Goto Tools -> Project Properties and select the tab protection and check the option "Lock project for viewing" and enter your password, confirm password.

This will protect your vba code from others. The persons who knows the password can access the vba code.

CS.

[krtxmrtz]

Goto Tools -> Project Properties and select the tab protection and check the option "Lock project for viewing" and enter your password, confirm password.

This will protect your vba code from others. The persons who knows the password can access the vba code.

CS.

Thank you cssriraman, I guess I now have a well protected word document. I hope it's quite foolproof and even damnfoolproof

[krtxmrtz]

Im not sure if 97 supporst signing of projects.

I'm afraid it doesn't, at least I've been unable to find it in the menus.