Hello Libby.... thanks for your help, as always!

I dont have much experience using the "Userinterfaceonly"
property. What happens when I set this to true? Is it
also an Application object property??



"Libby" wrote in message
...
Hi Robert,

Why don't you protect the sheets in the workbook open event, but set the
Userinterfaceonly property to true which will allow your code to run? You
can
then used the cells' locked property to lock and unlock various cells or
ranges.

Alternatively if you have a Excel 2003 or earlier you could disable the
Protection items in the Tools menu.

Libby