unchecking "format columns" doesn't help either.
And 97 doesn't seem to allow me to prevent users from selecting
protected cells (not that I can see anyway). They can't change anything in
these cells, but they can still go wandering around the spreadsheet, rather
than concentrating on the 6 important cells

Still interested in whether any significant number of US users use 97, or is
it just here in Hungary?
--
Pete


"Peo Sjoblom" wrote:

You could manually select the cells you want the users to be able to use,
then do formatcellsprotection and uncheck locked, then protect the sheet,
now the cells you unlocked will be open, you can also use an event macro to
control the input.
Normally if you design a workbook for 97-2003 it's better to design it in
Excel 97, everything that is available in 97 is available in later version
(except the help which was far better in 97). That way you won't get surpised
with things that were added in later versions


Regards,

Peo Sjoblom

"Pdek" wrote:

There wasn't a whole lot left to protect
The protect/shhet box asked for things that I wanted to allow the user to do.
The key thing is that I want the user to be able to enter data into 6 and
only 6 cells.
So I had "select unprotected cells" checked.
Also sometimes the answers come out too large, so I had "format columns" and
"format cells" checked as unprotected.
I've just unchecked the "format cells"
so all that's left unprotected is "select unprotected cells" and "format
columns"
I'll see if that works upstairs now, but it will be a pain (for large
numbers) if I have to uncheck "format columns"
Thanks
--
Pete


"Jerry W. Lewis" wrote:

The file format is the same, but 2002 has more protection options. You
have probably not protected enough things for 97 to recognize that the
sheet is protected.

Jerry

Pdek wrote:

What's the difference between Excel 1997 and Excel 2002 (in brief).
Is there a way to save a 2002 version file so it won't open in 1997 version
program?
Specific context:
I have a 2002 file that doesn't allow users to access protected cells.
This is essential for the file to work as designed.
When I open it in a 1997 version almost everything seems to work correctly,
except
that the users can access protected cells. Which f's everything up
completely!
I'd rather they weren't able to open it in 1997 version.
Also when I save it it in 1997 it sometimes turns off the conditional
formatting
which is only 90% as bad as the above problem.
Thanks for any help.