I have and excel document that has 2 worksheets, I want to be able to Protect the document so it's read only AND be able to track any changes to the history sheet which users can always see. Is this possible, I'm wanting to use this so that if changes are made by allowed users, all users can refer to the history sheet to see any/all changes made.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change Tracking Excel 2003
- Thread starter lisa626
- Start date
SkipVought
Programmer
Hi,
How can you, "...Protect the document so it's read ..."
AND...
have changes
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
