Hi Bob,
I already know that technique. I am just wondering if there is an
alternative way.
Thank you anyway.

"Bob Phillips" wrote in message
...
Martyn,

I can't see one.

There are a number of (limited) techniques to try and force the user to
open
with macros enabled. The most common of these is to open up on a page that
has a message saying that you need macros, with all other sheets hidden
(very hidden). If macros are enabled, you can unhide these sheets and hide
the warning one.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Martyn" wrote in message
...
Thanks both to Bob and sp00nix,
Just one follow-up question then...
Say I use Open file event for logging the accessed user, date, time that
the
workbook is opened.
But since this can only be activated IF the user has enabled using of
macros, is there no alternative to log an excel file usage on a PC
without
notice?


"sp00nix " wrote in message
...
in addition to that, if the user is opening the file on the network,
it
will ask them if they would like to open it with your macro. You can
create a digit signature to sign your macros so that it doesnt ask,
but
still, the user needs to accept your signature at least once before a
macro equiped workbook can be run without notice.
Mike


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