Hi,
which macro procedure command should be used in order to log that the
workbook is beeing opened without letting the user notice?
TIA

Martyn,

It depends what you mean by log, but I don't think you will find a command
to do it.

If you want to log a file being opened, you need to build the capability
yourself, and it wll depend where you want to log it.

--

HTH

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

"Martyn" wrote in message
...
Hi,
which macro procedure command should be used in order to log that the
workbook is beeing opened without letting the user notice?
TIA

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

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

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/

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/

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/