On Thu November 17 2005 14:40, + Cheryl Baker wrote: > [ MODERATED ] ******************** > Hello, > > > > We are in the testing stage of migrating our sales team from MS Office > to OpenOffice.org2.0. The management team creates Execl workbooks that > are password protected and the sales reps need to access and view these > workbooks. During a test, we had a user open an Excel 2002 password > protected workbook in OpenOffice Calc 2.0. The user was prompted for > the password to open the spreadsheet but the option to view the document > in read-only mode was not provided. Therefore the user was able to add > information to the spreadsheet and save those changes. We want the > sales team to use Calc to open password protected Excel workbooks but > not be able to edit and save changes. We have Excel Viewer but a sales > rep can still use OpenOffice. Is there anyway to achieve this using > CALC and Excel? >
I think that it should be possible by also setting a password on the sheet as well as the file. "Tools" -> "Protect Document" -> "Sheet". Please reply to [email protected] only -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
