G
Guest
I am trying to use a spreadsheet that I made in Excel2003, on a machine
running Excel97. Specifically I am getting an error in Excel97 when invoking
the protect/unprotect methods of the ActiveSheet.
When I step through the code in the VB editor - it works fine; however, when
I run the code (i.e. with F5 or from a command button on the worksheet) it
errors out on the unprotect/protect methods.
This completely baffles me.
Has anyone else had this type of problem? Am I missing something obvious?
running Excel97. Specifically I am getting an error in Excel97 when invoking
the protect/unprotect methods of the ActiveSheet.
When I step through the code in the VB editor - it works fine; however, when
I run the code (i.e. with F5 or from a command button on the worksheet) it
errors out on the unprotect/protect methods.
This completely baffles me.
Has anyone else had this type of problem? Am I missing something obvious?