View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KimberlyC KimberlyC is offline
external usenet poster
 
Posts: 124
Default Userfrom code in written in Excel 2000 running in Excel 97

Hi

I have a workbook that was written in Excel 2000.
It has a userforms with code behind it ....executed by a command button.
I sent it to a person running Excel 97 and every time they click on the
command button (on the userform) to run the code ...they get a run time
error message.
The code that starts to run is:
Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("TelephoneInfo").Unprotect (this is where it stops)


Is this due to the version differences?

Any help is greatly appreciated...
Thanks in advance!
Kimberly