I need to protect the worksheet from being printed out using the most
obvious printing controls. Disabling the toolbar printing icon was
easy, as was blocking the ctrl-P key combination but how to disable the
print item in the File menu??
The VB property for CommandBar.Controls which could manipulate the
submenu items is not documented.

thanks for help, Harri

in excel 2003TOOLSCUSTOMISECOMMAND TAB THEN CLICK REARRAGE COMMANDS
THEN SIMPLY DELETE PRINT COMMANDS.

"Harri Lumme" wrote:

I need to protect the worksheet from being printed out using the most
obvious printing controls. Disabling the toolbar printing icon was
easy, as was blocking the ctrl-P key combination but how to disable the
print item in the File menu??
The VB property for CommandBar.Controls which could manipulate the
submenu items is not documented.

thanks for help, Harri

In the VBA editor insert a new class module into your workbook called Class1
and include the following code:-

Dim WithEvents App As Application
Private Sub Class_Initialize()
Set App = Application
End Sub
Private Sub Class_Terminate()
Set App = Nothing
End Sub
Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean)
Cancel = True
End Sub

Now insert a new module and include the following code:-

Dim MyClass As Class1
Public Sub Auto_Open()
Set MyClass = New Class1
End Sub
Public Sub Auto_Close()
Set MyClass = Nothing
End Sub

It cancels any attempt to print from whatever option within Excel. It
obviously doesn't stop a user doing a print screen though.


--
Alan Moseley IT Consultancy
http://www.amitc.co.uk


"Harri Lumme" wrote:

I need to protect the worksheet from being printed out using the most
obvious printing controls. Disabling the toolbar printing icon was
easy, as was blocking the ctrl-P key combination but how to disable the
print item in the File menu??
The VB property for CommandBar.Controls which could manipulate the
submenu items is not documented.

thanks for help, Harri