Reply to thread

Message: [QUOTE="Gord Dibben, post: 3303379"] Tools>Options>Security>Macro Security. Set to "medium". You will get a warning, but your macros will run when you click on "enable". If just for your own personal use you can create a digital certificate using the "self cert" application that comes with Office. Look for selfcert.exe and run it to create a certificate. When added to the Trusted Sources, this by-passes the warning when that workbook starts. For help on certificates go to Answer Wizard and "certificates" Note: you must go into the VBE and Tools>Digital Certificate and select your certificate. Gord Dibben Excel MVP [/QUOTE]