Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
which command?
Hi,
which macro procedure command should be used in order to log that the workbook is beeing opened without letting the user notice? TIA |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
which command?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
which command?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
which command?
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
which command?
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
which command?
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
command code ( GOTO command) in formula | New Users to Excel | |||
command button add another command | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |