deyken
01-18-2012, 07:58 AM
Hi All,
I have writtena very extensive electronic document in Excel. This document will typically get reviewed and then authorised by several Top Management personnel. In order to avoid them having to print out this Excel document and run around the office buildings with it, I want it to be digitally signed.
Can I use MD5 Hash functions to do this in VBA and if so, how would I go about doing it?
For an example, I would like to encrypt this string: HP113145 as a particular user's digital signature. Everytime he types this in, it gets hashed behind the scenes and matched with the hashed version of this string previous saved to a SQL Server database. If it matches it flags this Excel document as having been digitally signed off by the current user.
Can something like this be done?
I have writtena very extensive electronic document in Excel. This document will typically get reviewed and then authorised by several Top Management personnel. In order to avoid them having to print out this Excel document and run around the office buildings with it, I want it to be digitally signed.
Can I use MD5 Hash functions to do this in VBA and if so, how would I go about doing it?
For an example, I would like to encrypt this string: HP113145 as a particular user's digital signature. Everytime he types this in, it gets hashed behind the scenes and matched with the hashed version of this string previous saved to a SQL Server database. If it matches it flags this Excel document as having been digitally signed off by the current user.
Can something like this be done?