Solved

User control on protected sheets?  (excel 2003)

Posted on 2011-03-18
4
181 Views
Last Modified: 2012-08-14
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
Comment
Question by:easycapital
  • 2
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 500 total points
ID: 35164847
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
 

Author Comment

by:easycapital
ID: 35167836
Good one!

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

Thanks,
JP
0
 

Author Closing Comment

by:easycapital
ID: 35184826
Thanks,
JP
0
 
LVL 24

Expert Comment

by:jimyX
ID: 35186318
It does not seem possible.
Sorry Easycapital, missed to comment earlier.

Cheers.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now