Just to add to Bernard's excellent advice, if you have xl2002 or later, you
have additional options. The first article refer to programming approaches
and the last two are manual approaches:
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
Using the Protection Object to Protect Your Worksheets
http://support.microsoft.com/kb/289270
How to apply different passwords or permissions to separate ranges in
worksheets in Excel
http://support.microsoft.com/kb/826923
Description of options that help you protect your worksheets in Excel 2003
and Excel 2002
--
Regards,
Tom Ogilvy
"mikeb" wrote:
Is there a way to protect certain cells or ranges on a worksheet and leave
the rest unprotected. There are certain ares that I don't want users to
change but want to allow them access to others. Can you please provide an
example.
Thanks,
Mike