Protection and ownership of excel Workbooks 1

[Stroppy]

Hi again all you excel maniacs,

I have been learning about Protection, Sharing, Tracking Changes, Passwords on Workbooks...

One thing I don't get it this. A worksheet or book is protected and shared. Changes are tracked and logged. Changes may be accepted or rejected. However, what is the use of this function is it is not restricted to just one "owner" of the sheet. If A, B, C and D are all using a workbook, then it seems that all four of them can accept or reject changes. Yet, if A is the "owner" of the workbook, then surely the accept/reject changes function should be available to him/her only?

Let me know if I have missed something...I am sure I must have.

Thanks again,

M

 

[xlbo]

The "Accept/Reject" changes happens on the fly. For it to work the way you wish, excel would have to keep a record of ALL changes by ALL users for as long a time as the owner didn't look at the workbook. This would require far more complexity and memory than excel has. Therefore...impossible Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde