Assigning Digital signature to a macro

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.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,650
Office Version
365
Platform
Windows
Which version of Excel (Office) are you using?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,650
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,102,360
Messages
5,486,387
Members
407,544
Latest member
mguevara

This Week's Hot Topics

Top