Problems - Office 2003 to 2010

[ISLANDBUOY]

Hello All,
I have created several Excel 2003 workbooks/sheets utilising vba code to guide/assist users, these have worked perfectly for some years. My company has now changed to Office 2010 which appears not to be backward compatible with 2003. eg. This simple 2003 code will not run in 2010:

Private Sub CommandButton1_Click()
'Unhides non blank rows
Application.ScreenUpdating = False
Unprotect
For i = 1 To 160
    If Cells(i, "a") = "" Then
        Rows(i).Hidden = True
    Else
        Rows(i).Hidden = False
    End If
Next i
Application.ScreenUpdating = True
Protect
End Sub
[uncode]

Can anyone advise on this problem?
Regards,
IslandBuoy

 

[Ruddles]

What do you mean by "will not run"? Do none of the statements get executed at all? Or does it run but not do what you expected?

If you add a breakpoint at the beginning of the code and click the button, what happens?

 

[Domenic]

Try...

[font=Verdana]ActiveSheet.Unprotect[/font]

and

[font=Verdana]ActiveSheet.Protect[/font]

 

[ISLANDBUOY]

Hi Ruddles,
Yes, no statements or commands run at all. Error reports are invariably "Compiler Error" and "Can't find project or library".
My IT guys merely say that 2010 is not backward compatible and re-do from scratch.
A. I find this very hard to believe, and,
B. I retire in a two months and don't have the time to do all again!!
Are you a 2010 user and have you come across this problem before?
Regards,
John

 

[Ruddles]

My money's on Domenic's suggestion. Give your IT guys a link to this forum and suggest to them that they get up to speed.

 

[ISLANDBUOY]

Hi Guys,
Thanks for your assistance, I think that I will retire quietly and leave the problems to someone else!
Regards,
IslandBuoy