View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh[_2_] Hari Prasadh[_2_] is offline
external usenet poster
 
Posts: 83
Default No Macros but Macro enabling message

Hi DM,

I create a new-workbook with Ctrl+N and then check out the VBE and see that
Option Explicit is added by VBE automatically (I have the option for it
checked in my VB, so I believe new wkbooks have this line added auto.)

I saved the above wkbok with no changes and reopened the same in a new excel
session. I did NOT get any Macro warnings, so not sure whether Option
explicit is enough to trigger messages.

Thanks a lot,
Hari
India

"DM Unseen" wrote in message
ups.com...
Option Explicit is enough to trigger macor warnings!

DM Unseen