change history with no [shared] file name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Murf2 - 19 Oct 2005 23:29 GMT

I am setting up a file that will track changes made to it. A coworker feels
as though her work is being sabotaged. Others need to have access to the
files for business purposes but should not make wholesale changes. When the
file is opened, the top of the screen displays the file name followed by "
[shared] ". Is there a way to eliminate this descriptive term so people don't
know the changes are being tracked?

Thanks
Murf2

Reply to this Message

Alan - 20 Oct 2005 03:44 GMT

> I am setting up a file that will track changes made to it. A
> coworker feels as though her work is being sabotaged. Others need to
[quoted text clipped - 6 lines]
> Thanks
> Murf2

Hi Murf2,

It *sounds* like you have an administrator type person, and the users.

Presumably the users are updating data, but not changing the logic /
flow of the workbook?

If so, then why not replace the one file with two, where data can be
held and updated in one, and the logic / business rules maintained in
the other.

You could also consider moving to, say, Access, but the business case
for that is often not strong enough to warrant going there.

HTH,

Alan.

Signature

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:

6f7chu602@sneakemail.com

This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address

Reply to this Message

Murf2 - 20 Oct 2005 14:51 GMT

Thanks for the reply. The idea here is to be able to track changes with out
the person making the changes being aware of it. This is not a typical
business situation. I want to "catch" someone making changes they shouldn't
be. This requires that the file look exactly as it does normaly. The
[shared] note in the title is potentially notifying people that something is
different with the file.

Is there anyway to remove the "[shared] marking?

> > I am setting up a file that will track changes made to it. A
> > coworker feels as though her work is being sabotaged. Others need to
[quoted text clipped - 24 lines]
>
> Alan.

Reply to this Message

Alan - 21 Oct 2005 01:50 GMT

> Thanks for the reply. The idea here is to be able to track changes
> with out the person making the changes being aware of it. This is

not

> a typical business situation. I want to "catch" someone making
> changes they shouldn't be. This requires that the file look exactly
> as it does normaly. The [shared] note in the title is potentially
> notifying people that something is different with the file.
>
> Is there anyway to remove the "[shared] marking?

You could use the worksheet_change event to log every change to cells
in a worksheet I guess - not sure how robust or difficult to implement
that would be though.

HTH,

Alan.

Reply to this Message