VB Code working in 2010 but not 2003?

Hello Everyone,

I built a sheet in Excel 2010 that contains the following VB code:

Private Sub Workbook_Open()
Application.CommandBars.FindControl(ID:=2521).Enabled = False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars.FindControl(ID:=2521).Enabled = True
End Sub

this works fine in 2010 but now the sheet needs to run in Excel 2003. The problem
is that when I open the sheet in 2003 I am met with the following error message:

Run-time error '91':
Object variable or With block variable not set

I am just trying to disable the toolbar printer icon so that I cannot be pressed!
In 2010 the above code fades the icon out disabling it.

I only want the user to print using a button that has a macro attached to it already. The reason is because if they print using the print button on the toolbar every page will print! The macro that is attached to the print button that I have created will print only a specified page break range! If they print from the tool bar button 47 pages will print instead of just 1!

Any help is much appreciated.

Regards,

Margate

If you want to prevent the user from printing the file, why not just like this...?

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

(the reason why it works in 2010 and not in 2003 is that the id numbers are different -- in 2003 the code number for print is 4)

Please click the * below if this helps

You will get that if the control is not visible on a commandbar.

Why not set the print area if all you want is to restrict what is printed?

In xl2003 I'm sure you could still use CTRL+P to print even if the button was visible and disabled.

Why not extend JasperD's suggestion.

If your print macros set the value of a public variable you can then check that and print the relevant section or simple cancel the print.