Colleagues can't use my macro enabled workbook

[Pookiemeister]

I created several macros in a workbook and sent to my colleagues to use but they are unable to open it due to security issues. I have a digital signature assigned to this file. Originally, I had a similar issue when I wrote the code on my personal laptop and then moved it over to my work laptop and I'm not sure what I did to resolve it, but I continued working on the code with my work laptop.
My colleagues clicked on "Enabled content" but it did not work.
I went to:
Files ->Options->Trust Center->Trust Center Settings ->Macro Settings->Clicked "Disable VBA macros except digitally signed macros"->Clicked "Enable Excel 4.0 macros when VBA macros are enabled" and "Trust access to the VBA project object model"

 

[6StringJazzer]

Is your certificate from a CA, or self-signed?

 

[Pookiemeister]

self signed, I believe

 

[Pookiemeister]

Just to make sure, how can I check to see if it I self signed or CA? Thanks

 

[rikvny02]

Are you emailing this file? Is it possible it can be moved to a company shared folder for your colleagues to view?

 

[Pookiemeister]

@rikvny02 the only option is to move it to TEAMS .

 

[MARK858]

If you emailed it did they unblock the files?

 

[6StringJazzer]

If you used a CA you would know it because you would have to provide identification and pay a fee. Microsoft has a self-signed cert function but it's intended for development, not security. I don't think it will work when you sent it someone else.

I think MARK858 is on the right track with checking your colleague's security settings for which locations are safe.

 

[MARK858]

I think MARK858 is on the right track with checking your colleague's security settings for which locations are safe.

I was thinking more that because Windows blocks any files with macro's received from another computer by default whether downloaded or sent by email (for example when installing XL2BB), then you need to unblock the file or put it in a trusted location (of course the company might also have other security settings setup on top of this).

Below is the instruction on how to unblock a file in the link under "If you have difficulties installing the add-in" in the installation instructions for XL2BB