Mickey,

I use your macros in one of my programs but it disable the print options
for all my excel files open... can I have it apply only for the excel file I
am executing the macro?

"מיכ�ל (מיקי) �בידן" wrote:

You should try:
====================
Sub Disable_Print()
Application.OnKey ("^p"), ""
CommandBars("Worksheet Menu
Bar").Controls("File").Controls("Print...").Enable d = False
CommandBars("Standard").Controls(6).Enabled = False
End Sub

Sub Enable_Print()
Application.OnKey ("^p")
CommandBars("Worksheet Menu
Bar").Controls("File").Controls("Print...").Enable d = True
CommandBars("Standard").Controls(6).Enabled = True
End Sub
============
Micky


"Alberto Ast" wrote:

I would like to force the users of my program to use my print command... and
not be able to use the standard excel options to print...

can I disable those buttons/options like

File/print
Print icon
etc....