BUD

Hi, i have some problems with the macro security in Excel. I've made an Excel file with a button who send an email. The Excel file will be use by a lot of user.. But if the macro security of the user is set to medium or high, it will ask a question like:

Do you want to enable or disable macro?

wiith three choices
enable, disable, cancel

But what can i do the drop this message????

Wamphyri

Create a digit signature.

BUD

how can I create this?

Wamphyri

There are some instructions here. Hopefully, it will work.

BUD

But can you explain me what is it, the digit signature? Do i have to create this on each machine, or is just on the file?

Wamphyri

From what I understand just on the VBA program. I was going to be trying it out early next week, since I have the same problem as you.

BUD

okay, so if i understand, i have to create my digit signature on each machine. And he don't have any other solution?

Wamphyri

No, you attach your digital signature to your program. Then install your program on each computer.

BUD

It's not a program. It's only an Excel file with a button who send by email this file. Do you understand what I mean? So the user fill the file, with his personal information, and when he click on the button, the file is saved, and send at a person. So i don't want any error message about the security.

Wamphyri

Then goto the excel VBA (where your code for your email button is). Tools -> Digital Signature. Choose a signature to add to your Excel code (after you have created a signature first.) Then destribute your excel file.

BUD

Okay. And with that, event if the security is set to High, or medium, it will never ask to enable or disable macro?

Wamphyri

I believe it will ask "if you wish to trust this source?" If you select it as a source to always trust then it will not ask again. That is from what I understand. Like I said earlier, I'll be doing this next week.

BUD

okay, thanks
I will try it. And if it's work, i will write back.

BUD

Hey Carl, i tried it. When you open the file, he has an Security Warning. But this warning comes just at the first timeyou open it.

Wamphyri

Yeah, I thought so. Does it ask you if you always want to trust this source?

BUD

yes, you can check this option in the warning!!!!!!!