ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disabel print preview (https://www.excelbanter.com/excel-programming/390235-disabel-print-preview.html)

Javier U.

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


FSt1

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


Ron de Bruin

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


FSt1

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



Javier U.[_2_]

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



Ron de Bruin

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




All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com