Ooops - forgot! If you are using Excel 2007 you will need to enable all macros in the trust center, and make sure you add the location of the dll to the list of trusted folders.
Cogito eggo sum – I think, therefore I am a waffle.
Thanks genomon. I am using excel 2003 and antivirus shouldn't have anything to do to with it (i think).
When i rename my DLL i can compile it no problem, and even without renaming, it allows me to compile. it's usually when i close excel to add some changes in VB6 and then compile when i getting this message about permission.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.