View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Excel Enable Macro message

Hi
you can't do this, if the user opens the workbook manually. The only
way would be to set the security level to 'low' but I wouldn't
recommend this.


--
Regards
Frank Kabel
Frankfurt, Germany
"Worsty " schrieb im
Newsbeitrag ...
Could someone please give me the code to automatically enable Macros

in
Excel so that the user doesn't get the prompt when opening the
workbook?

Thanks,


---
Message posted from http://www.ExcelForum.com/