LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
want to record date for each time I update a file PattyR Excel Discussion (Misc queries) 2 May 27th 09 05:40 AM
How can I get the system date & time for different cell record Get System Date & Time Excel Discussion (Misc queries) 8 January 9th 08 01:20 AM
Mac issue with macro recording user login & date (run time error ' Linking to specific cells in pivot table Excel Programming 5 May 8th 07 04:52 PM
Macro to record user name and date/time Maddoktor Excel Discussion (Misc queries) 0 December 8th 05 10:03 PM
Record Macro - Record custom user actions Sal[_4_] Excel Programming 1 December 23rd 04 03:18 PM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"