change history

lucky · Mar 21st, 2002, 08:08 AM

Hi All
I wish to protect a worksheet and also record any change history in certain cells. One person has the password to unprotect that worksheet and make changes which I wish to record. If I use the 'share workbook' functionality in Excel it does not allow me to protect the workbook from other users making changes.
Can anyone help.
Rgds
Lucky

NateO · Mar 21st, 2002, 09:29 AM

Lucky

Try tools->protection->Protect and Share Workbook.....

lucky · Mar 21st, 2002, 10:27 AM

Nate
That still allows other users to make changes to the workbook and save. It only protects the history.
Any other ideas??

NateO · Mar 21st, 2002, 10:44 AM

You can put the file on your hard drive.

NateO · Mar 21st, 2002, 11:03 AM

When you save the file (do "Save As"), click tools in the upper right of the dialog, select General Options and enter the appropriate passwords to open or modify the hile.

Hope this helps.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-03-21 11:04 ]

Mar 21st, 2002, 09:29 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Lucky Try tools->protection->Protect and Share Workbook..... __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Mar 21st, 2002, 10:44 AM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You can put the file on your hard drive. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 08:08 AM	#1
lucky New Member Join Date: Feb 2002 Posts: 18	Hi All I wish to protect a worksheet and also record any change history in certain cells. One person has the password to unprotect that worksheet and make changes which I wish to record. If I use the 'share workbook' functionality in Excel it does not allow me to protect the workbook from other users making changes. Can anyone help. Rgds Lucky

Mar 21st, 2002, 10:27 AM	#3
lucky New Member Join Date: Feb 2002 Posts: 18	Nate That still allows other users to make changes to the workbook and save. It only protects the history. Any other ideas??

Mar 21st, 2002, 11:03 AM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	When you save the file (do "Save As"), click tools in the upper right of the dialog, select General Options and enter the appropriate passwords to open or modify the hile. Hope this helps. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-03-21 11:04 ]