View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Satyendra_Haldaur[_2_] Satyendra_Haldaur[_2_] is offline
external usenet poster
 
Posts: 28
Default Disabling Excel 2000 worksheet printing

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