I am in need of a solution to track changes by Windows Usernames.
The organization I work for has the default Excel UserName set to the
Organization name. Even if you change it from the Options menu to your name,
the next machine you log onto still has Excel username listed as the
Organization Name.

I need to track changes made to a spreadsheet and this makes it pretty close
to impossible to tell who changed what. Is it possible to use the Windows
Logon name in the track changes? Or is there a way I can have a prompt to
enter initials or name when a change is made to the spreadsheet?

Any other suggestions please?

Thanks,
Luke Slotwinski

Hi Luke,
See the last topic in
http://www.mvps.org/dmcritchie/excel/property.htm

Or directly to
http://groups-beta.google.com/group/...1a98111e7cd5d7

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Slotwinski" wrote in message
...
I am in need of a solution to track changes by Windows Usernames.
The organization I work for has the default Excel UserName set to the
Organization name. Even if you change it from the Options menu to your name,
the next machine you log onto still has Excel username listed as the
Organization Name.

I need to track changes made to a spreadsheet and this makes it pretty close
to impossible to tell who changed what. Is it possible to use the Windows
Logon name in the track changes? Or is there a way I can have a prompt to
enter initials or name when a change is made to the spreadsheet?

Any other suggestions please?

Thanks,
Luke Slotwinski

Is there a way to incorporate that into Excel's Track Changes. Or a way I
could log who made changes to specific fields using that function.

Also... Could I insert that function into an Excel Cell to put the username
into a cell?

Thank you for your help,
Luke Slotwinski

"David McRitchie" wrote:

Hi Luke,
See the last topic in
http://www.mvps.org/dmcritchie/excel/property.htm

Or directly to
http://groups-beta.google.com/group/...1a98111e7cd5d7

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Slotwinski" wrote in message
...
I am in need of a solution to track changes by Windows Usernames.
The organization I work for has the default Excel UserName set to the
Organization name. Even if you change it from the Options menu to your name,
the next machine you log onto still has Excel username listed as the
Organization Name.

I need to track changes made to a spreadsheet and this makes it pretty close
to impossible to tell who changed what. Is it possible to use the Windows
Logon name in the track changes? Or is there a way I can have a prompt to
enter initials or name when a change is made to the spreadsheet?

Any other suggestions please?

Thanks,
Luke Slotwinski

Hi Luke,
Track Changes is really (in my opinion) only suitable for something
which is hardly going to be changed before a final distribution, there
is a lot of overhead in recording every cell change.

See my page
Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm

I had to go to my backup a few times because I didn't know how to
turn it off, and you will see how to turn it off there. I doubt that
you would be able to tie into that. But you could use the Track Changes
along with recording who actually saved the file and use the two
reports together. See the related area of that page (first item)
that has an Event macro for Before Save and you could use the
system's userid there, along with the username known to Excel.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Slotwinski" wrote in message
...
Is there a way to incorporate that into Excel's Track Changes. Or a way I
could log who made changes to specific fields using that function.

Also... Could I insert that function into an Excel Cell to put the username
into a cell?

Thank you for your help,
Luke Slotwinski

"David McRitchie" wrote:

Hi Luke,
See the last topic in
http://www.mvps.org/dmcritchie/excel/property.htm

Or directly to
http://groups-beta.google.com/group/...1a98111e7cd5d7

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Slotwinski" wrote in message
...
I am in need of a solution to track changes by Windows Usernames.
The organization I work for has the default Excel UserName set to the
Organization name. Even if you change it from the Options menu to your name,
the next machine you log onto still has Excel username listed as the
Organization Name.

I need to track changes made to a spreadsheet and this makes it pretty close
to impossible to tell who changed what. Is it possible to use the Windows
Logon name in the track changes? Or is there a way I can have a prompt to
enter initials or name when a change is made to the spreadsheet?

Any other suggestions please?

Thanks,
Luke Slotwinski