Hubert Fitch wrote:
----- Original Message ----- From: "Sandy" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, November 16, 2006 1:03 AM
Subject: Re: [users] Excel spreadsheets should not open with cells
protected
Hubert Fitch wrote:
My Excel spreadsheets must open like they were created, with desired
columns of input cells unprotected.
How can I change the behaviour of open office which adds protection
when spreadsheets are opened, so that my customers can immediately
use their spreadsheets as they have always been able to do in the past?
Hubert Fitch
Perhaps you could clarify what is happening.
You use OpenOffice Calc to create an .xls spreadsheet. When someone
uses Excel to open the spreadsheet, cells have somehow become
protected. Is that it? (I cannot test it myself but others who have
both software applications may do so.)
I take it that's a yes.
In OpenOffice, cells are formatted by default with cell protection
enabled. That protection does not become effective in OpenOffice unless
you use Tools >Protect Document >>.
This is only a guess on my part. Perhaps the cell protection in the
cell formatting is sufficient without more in Excel. (I'm assuming that
you have not selected either option with Tools >Protect Document.)
If that is the case, you could alter the default cell setting by using
F11. Right-click on "Default" and select "Modify". You get a
dialogue. Choose the last tab, which is named "Cell Protection".
De-select any box which has been selected.
Since you do not, presumably, want to do that for every document, you
could alter a blank spreadsheet in that way and save it as a template
using File >Templates >Save. If you wish, you could make it your
default template with File >Templates >Organise.
If it is the default template, you can use it with File >New
>Spreadsheet; otherwise, you have to use File >New >Templates and
Documents.
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
