Determining if Macro Can Run
Mike,
I use the message sheet approach in I explain that tells users that (1) macros
must be enabled for the workbook to function; (2) the Security Level must be
set to Medium using Tools- Options- Security- Macro Security- Security
Level tab; and (3) 'Trust access to Visual Basic Project' must be checked using
Tools- Options- Security- Macro Security- Trusted Sources tab
-- Dennis Eisen
|