Macro security and trusting a workbook.

[Welshbird]

So, with much help from here, I've finally finished by dynamic reporting tool in Excel. And its been well received!

However, the security settings on user PC's will not allow the macro to run, and they don't have rights to change the security settings (and IT really don't want to change that).

Our IT guy here added a digital certificate (as the self-cert I'd added wouldn't allow them to trust me as a publisher) and now they just see a message asking them to insert a smart-card....

Any suggestions would be hugely gratefully received, as at the moment my first project at this new job can't actually work.

(Should have discussed with our IT guys first!)

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

Could this have anything to do with having used a password to protect my code from view?

Surely not....

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

If the user's pc's are locked down, not much you can do.

It is absoutely rediculous to do that with a tool like Excel. You loose half its functionality.

Check out Add-Ins.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Welshbird]

Would a certificate allow them to trust it?

The users we're talking about need to have a way that we can set up this book as 'trusted to run macro's' really - and I think that means having a real certificate so they can then trust the publisher.

Opinions?

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[combo]

There are no trusted workbooks. There are trusted publishers. As Skip suggests, consider packing your project into add-in. Quick test indicates that the standard directory where excel tries to save workbook as an add-in is a "trusted place". There are no problems with non-signed macros even in highest security level set (excel 2003).

combo

 

[combo]

Ops, the add-ins policy is set by trusting all add-ins and templates.

combo

 

[Welshbird]

My ICT director has just pointed out that I just need to set a folder on the users machine a s tursted location, and that will be fine!

Seems like a very easy fix to me.

Going to go and test on someone elses machine any minute now.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen