nehachoubey
Board Regular
- Joined
- Aug 17, 2011
- Messages
- 52
I have created a digital signature with microsoft office tools. Now how do i assign to my workbook so that if i send it to someone, they use it without doing any settings.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Assigning Digital signature to a macro
- Thread starter nehachoubey
- Start date
-
- Tags
- digital signature macro
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,244
- Office Version
- 365
- Platform
- Windows
Go in to the VB Editor, and from the Tools drop-down menu select "Digital Signature", and choose your signature and then save.
The first time someone opens this file, they will still need to accept your digital signature. If they select "View Certificate" and go through the whole process, and at the very end select "Accept all documents signed with this signature", they will not need to do it every time. Every file signed by you will automatically be accepted and macros will automatically be enabled for all files signed by you (for all files they open on that workstation).
The first time someone opens this file, they will still need to accept your digital signature. If they select "View Certificate" and go through the whole process, and at the very end select "Accept all documents signed with this signature", they will not need to do it every time. Every file signed by you will automatically be accepted and macros will automatically be enabled for all files signed by you (for all files they open on that workstation).
Upvote
0
