• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tracking changes to a spreadsheet

Carley

New Member
Good Afternoon all from a thankfully sunny UK!


I am in the process of building individual productivity spreadsheets for agents and some of the feedback I have recieved is that the current spreadsheet they have, they do not like it password protected.

The managers do however want an audit trail of who has updated the form to ensure agents are updating thier own forms.

I am using Excel 2010 and tried the track changes, but this doesn't really work.

I then came up with the idea of using a User form in VBA that opens when the form opens and they enter there name.

I was wondering if there was a way that excel could automattically pull the login id from the person entering the name on the user form and also enter that onto the spreadsheet?


The code I have for entering the detail on the spreadsheet from the userform is:

Private Sub CommandButton1_Click()

Dim emptyRow As Long

'Make Sheet1 Active

Worksheets("admin").Visible = True

Worksheets("admin").Activate


'Determine emptyRow

emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1

'Export Data to worksheet

Cells(emptyRow, 1).Value = TextBox1.Value

Worksheets("admin").Visible = False

Unload Me

Worksheets("start").Activate

end sub
 
Good day Carley


It may be sunny down Orpington way but not here in North Lincs :(


Is there a problem with traking changes via the review tab?
 
Hi Bob,


As it is an individual report, putting as a shared document is not really an option.
 
Hi, Carley!


Should this help? It retrieves the login user name.

-----

Code:
Environ("USERNAME")

-----


If needed further information, give a look at this link:

http://chandoo.org/forums/topic/security-properties-of-a-cell#post-30446

Download the file and check module modAccountInfo.


Just advise if any issue.


Regards!
 
Back
Top