those work in excel97 for me, are there any passwords?

--


Gary


"norman1nz" <norman1nz.1x0mec_1129500317.3233@excelforum-nospam.com> wrote
in message news:norman1nz.1x0mec_1129500317.3233@excelforum-nospam.com...
>
> Hi I have created a program that unprotects the reprotects as users
> press buttons etc which works fine in Office 2000 and office 2003, but
> the users of the program are still running Office 97, with which the
> code returns an error.
>
>
> This is my general syntax:
>
>
> Sub ProtectAll()
> Sheets("sheet1").Protect
> Sheets("sheet2").Protect
> Sheets("sheet3").Protect
> End Sub
>
>
> Sub UnProtectAll()
> Sheets("sheet1").Unprotect
> Sheets("sheet2").Unprotect
> Sheets("sheet3").Unprotect
> End Sub
>
> Any advice would be greatly appreciated.
> As far as I can see the help from 97 vs 2003 is the same
>
>
> --
> norman1nz
> ------------------------------------------------------------------------
> norman1nz's Profile:
> http://www.excelforum.com/member.php...o&userid=27155
> View this thread: http://www.excelforum.com/showthread...hreadid=476660
>