View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
achidsey achidsey is offline
external usenet poster
 
Posts: 100
Default Digital Certificates


Excel Experts:

I recently started work at a medium sized firm. I have a few projects to
automate spreadsheets that will be used by myself and also other users.

I recently added some VBA code to a spreadsheet, but when another user
opened the spreadsheet, she wasn't able to use the macros.

This is my first situation using Excel 2003 and from searching around Help,
it seems I need to sign my macros with a digital signature in order for other
people to use them.

What is the best way for me to go about making it possible for others to use
files with VBA code I've written and for the others to be able to run the
macros. My firm doesn't want to spend money to get certificates from
Verisign or anything like that, and I don't think that's necessary anyway.

Do I just create my own digital certificate and then have the other users
add me as a trusted provider?


Thanks, Alan
--
achidsey