View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Elizabeth Elizabeth is offline
external usenet poster
 
Posts: 71
Default Can VBA be used to list macros

Dave:
IT WORKS!!! This is so great! When I received the last error message I had
confirmed that the project was digitally signed, but didn't know about the
"Trust access..." box. Thank you.
I am in awe of the level of knowledge that everyone has who was involved in
this string, as well as everyone's willingness to share their knowledge. I
am now going to foward this macro to friends who know even less about VBA
than I do.
Elizabeth

"Dave Peterson" wrote:

Back to excel.
Tools|macro|security|trusted publishers tab|check that Trust access to Visual
basic project.

This is a user by user setting (FYI). If you change your setting, it doesn't
affect anybody else.