Hello,

I'm trying to disable the print CommandBar items and
toolbar buttons from a specific Excel workbook on the
WhenClick event of a custom button. The problem is that
in so ding, I end up disabling the functionality for any
workbook I open after executing my code. Any ideas on how
I can limit the sciope to the individual workbook I'm
working on? I'm sing Excel XP. Here's a snippet of my
code:

Toolbars("Standard").ToolbarButtons(7).Enabled = False

With CommandBars("File")
.Controls("Print...").Enabled = False
.Controls("Print Preview").Enabled = False
End With