ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro to record user name and date/time (https://www.excelbanter.com/excel-discussion-misc-queries/59526-macro-record-user-name-date-time.html)

Maddoktor

Macro to record user name and date/time
 
Is it possible to record a macro that when someone on the network opens my
workbook that it records the user's name, time and date on a hidden
protected worksheet?

Can this then be expanded further by if the user then changes something,
either adds, modify, or delete information from my workbook then the user's
name, date, time and changes (including worksheet name, cell co-ordinates
(i.e. A1) and information modified from and modified too) are recorded on a
hidden protected worksheet?

Thanx in advance.

Maddoktor




All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com