Problem: Worksheets("New Style 2006").Unprotect Password:="naPrint"

Why do I get get a run time error 1004 when using this command on Excel 97?

The above script is in sub of a Control Command Button.

Rgds
Neil

Set the TakeFocusOnClick property of the Commandbutton to false. This is a
bug in xl97.

--
Regards,
Tom Ogilvy


"Karoo News" <neil.null@orange.net> wrote in message
news:7RWdnXuN-prRvUPeSa8jmw@karoo.co.uk...
> Why do I get get a run time error 1004 when using this command on Excel
97?
>
> The above script is in sub of a Control Command Button.
>
> Rgds
> Neil
>
>
>