Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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