• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

User control on protected sheets? (excel 2003)

If a sheet within a workbook is protected.  Can one know which user (from the authorized ones), unprotected the sheet and entered figures?

Trying to achieve knowing how changed what on a specific sheet.  Any ideas?
JP
0
easycapital
Asked:
easycapital
  • 2
  • 2
1 Solution
 
jimyXCommented:
From the menu -> Tools -> Track Changes -> Highlight Changes and set your options.

And when it's changed by someone else and saved, and when you open it you can go to:
Tools -> Track Changes -> Accept or Reject changes and you will get the details you are looking for plus having the ability to accept or reject the changes.
Track-Changes.JPG
0
 
easycapitalAuthor Commented:
Good one!

Can I set it up so that I am the only one that can accept the changes?

Thanks,
JP
0
 
easycapitalAuthor Commented:
Thanks,
JP
0
 
jimyXCommented:
It does not seem possible.
Sorry Easycapital, missed to comment earlier.

Cheers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now