Hi.

I have a program written in Excel 97, that uses the
following statement:

Sheets("Loan").Protect UserInterfaceOnly:=True

This works correctly in that it doesn't allow the user to
type values into cells, but it does allow the macros to
change the values.

Note that this Excel 97 macro is working even though I
have Excel 2002.

My problem is that when I creat a new workbook and try to
use the exact same statement, it does not
work. "UserInterfaceOnly" is not one of the available
arguments.

Could someone shed some light on this?

Thanks,
Mike.

The UserInterfaceOnly argument applies only to individual worksheets and not
to workbooks.

--

Vasant


"Mike" wrote in message
...
Hi.

I have a program written in Excel 97, that uses the
following statement:

Sheets("Loan").Protect UserInterfaceOnly:=True

This works correctly in that it doesn't allow the user to
type values into cells, but it does allow the macros to
change the values.

Note that this Excel 97 macro is working even though I
have Excel 2002.

My problem is that when I creat a new workbook and try to
use the exact same statement, it does not
work. "UserInterfaceOnly" is not one of the available
arguments.

Could someone shed some light on this?

Thanks,
Mike.