| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabel print preview
Hi ....
please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabel print preview
hi
this would be in general Application.CommandBars("Standard").Controls(7).En abled = False where standard is the name of the command bar and controls is the position on the command bar from the left. to turn in back on have enabled = true. Regards FSt1 "Javier U." wrote: Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabel print preview
Look out
If users add or remove controls Controls(7) is not working correct See this page for example code that use the ID http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FSt1" wrote in message ... hi this would be in general Application.CommandBars("Standard").Controls(7).En abled = False where standard is the name of the command bar and controls is the position on the command bar from the left. to turn in back on have enabled = true. Regards FSt1 "Javier U." wrote: Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabel print preview
thanks ron
FSt1 "Ron de Bruin" wrote: Look out If users add or remove controls Controls(7) is not working correct See this page for example code that use the ID http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FSt1" wrote in message ... hi this would be in general Application.CommandBars("Standard").Controls(7).En abled = False where standard is the name of the command bar and controls is the position on the command bar from the left. to turn in back on have enabled = true. Regards FSt1 "Javier U." wrote: Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabel print preview
Thanks FSt1 and Ron..... the options works but in not good mode for us. My
problem is ... the users need to see the print preview form... but into print preview form i need to disable the print button. the another print options is in the (menu view) page break preview. The users need to see this form, but we need to disable the option in the contextual menu "Page Setup" Thak you very much for your help... and sorry form my bad english. "FSt1" wrote: thanks ron FSt1 "Ron de Bruin" wrote: Look out If users add or remove controls Controls(7) is not working correct See this page for example code that use the ID http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FSt1" wrote in message ... hi this would be in general Application.CommandBars("Standard").Controls(7).En abled = False where standard is the name of the command bar and controls is the position on the command bar from the left. to turn in back on have enabled = true. Regards FSt1 "Javier U." wrote: Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
disabel print preview
Hi Javier
I not think it is possible to disable this button in the Page Setup dialog. But i good be wrong -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Javier U." wrote in message ... Thanks FSt1 and Ron..... the options works but in not good mode for us. My problem is ... the users need to see the print preview form... but into print preview form i need to disable the print button. the another print options is in the (menu view) page break preview. The users need to see this form, but we need to disable the option in the contextual menu "Page Setup" Thak you very much for your help... and sorry form my bad english. "FSt1" wrote: thanks ron FSt1 "Ron de Bruin" wrote: Look out If users add or remove controls Controls(7) is not working correct See this page for example code that use the ID http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "FSt1" wrote in message ... hi this would be in general Application.CommandBars("Standard").Controls(7).En abled = False where standard is the name of the command bar and controls is the position on the command bar from the left. to turn in back on have enabled = true. Regards FSt1 "Javier U." wrote: Hi .... please help me wi this problem........ in Microsoft Office Excel 2003 i need to disabled the print botton that it appears available when is selectec to the option of print preview. I am developing shared add-in in visual studio 2005 C#. Please its collaboration with the code to disabled this botton. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
| Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
| print preview v page break preview | Excel Discussion (Misc queries) | |||
| cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
| Why does macro speed slow after Excel Print or Print Preview? | Excel Programming | |||
Hybrid Mode
