View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DennisE DennisE is offline
external usenet poster
 
Posts: 66
Default 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