my experience of shared workbooks with this is that when opening it windows prompts that "book contains macros do you wish to enable macros?" and one clicks yes and can work ok on the book, would it cause a prob if the shares saved as?
selfCert, as described by VoG™, this is the best method...
What your users will have to do is set the security setting to "Medium"...
Then when they open one of your workbooks with macros they will get the warning prompt...
The important thing is that on this warning prompt dialogue there is a box that can be ticked that says something like, "always trust workbooks digitally signed with this signature"
They can then set the security setting back to high.
However, (always one!!), I have found that at my place of work the security on the network is such that it doesn't recognise the certificate I have made at home as a "safe" one, and wont recognise it as a "Trusted source". Unfortunately it takes ages to check and tell you that. My macros can still be run, but only if the security setting is not on "High".
I had a further read into the link that VoG™ offered.
There is a minor caveat! It only works across a network. :o((
Short of having someone professional certify the thing, it looks like I'm stuck with persuading the end user to to use 'medium' security and then enable the macros. However, I will point out that if they have a good, up-to-date virus checker, they can (at their own risk) set the security to low. And I will include a statement that the workbook has been sent out as fully virus checked and virus free.
I can get it to work in my 'home' environment as well, but having read the 2003 details, it was on about it being OK across internal networks once accepted, but seemed to insinuate that once it left the network it wouldn't.
As there have been no complaints about the beta and version 1 of my 'software' (coz I explained about the virus protection in the 'User Guide'), I'm not going to lose the last two hairs left on my head chasing this little bit and keep my revisions that I'm making for version 2 down to the more needed additions and changes that have been suggested by users. That's enough fun as it is - as you may have guessed from recent other questions that I've posed here. ;o))
This thread is now locked and can not be replied to.