Shhhhsecretsquirrel
asked on
How to log username of the users who change cells in a Shared workbook
URGENT need VB Script.
MS Excel 2003 - I have a number of worksheets containing numerous rows within a Shared workbook.
I want to log the username and date in a cell of a row of who has changed specified cells within that worksheet. Need to work on all work sheet.
Also would like to hide LOG columns from Users so only people with a password can Unhide them
see attached worksheet
Book1.xls
MS Excel 2003 - I have a number of worksheets containing numerous rows within a Shared workbook.
I want to log the username and date in a cell of a row of who has changed specified cells within that worksheet. Need to work on all work sheet.
Also would like to hide LOG columns from Users so only people with a password can Unhide them
see attached worksheet
Book1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I aggree with rspahitz...why use VB when you can use the built in features...also there is a History of changes that you can printout etc.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
In Excel 2007 that would be
Tab Review, group Changes, item Track Changes, sub item Highlight Changes.
The rest should be self-evident.