I've been searching the board and the help files for this, and although I've found many other useful things, I haven't found the answer yet!
I don't want to disable the "macros must be enabled" warning when Excel opened -- I happen to find it useful! I just want to detect whether the user clicked "No" so I can give him a message explaining why the workbook is now such a dismal failure...
Can anyone tell me if/where this information is stored that I can detect it with VBA?
Thanks!
Catherine
This message was edited by artslave on 2002-06-28 09:43
I don't want to disable the "macros must be enabled" warning when Excel opened -- I happen to find it useful! I just want to detect whether the user clicked "No" so I can give him a message explaining why the workbook is now such a dismal failure...
Can anyone tell me if/where this information is stored that I can detect it with VBA?
Thanks!
Catherine
This message was edited by artslave on 2002-06-28 09:43