print preview menu

C

Cesar Zapata

explicate un poco mejor. que tratas de hacer.

are you trying to disable the print preview form the menu bar and the
toolbar?
 
L

lortiz

lo que yo deseo hacer es lo siguiente:

tengo una userform1 con 1 controlbuttom llamado imprimir fomato este
boton muestra en forma de "print preview" la hoja o el formato
deseado:

woksheets("hoja1").printpreview

y lo que necesito es saber si existe una forma para desabilitar ciertos
botones del menu de print preview es decir solo dejar activos algunos
como: next, preview, close, print.

esto para eviar que los usuarios cambien los parametros del setup de la
hoja o los margenes

espero que me ayudes y creo que algien llamado joe tambien pregunta lo
mismo
 
P

Paul M

Hi Lortiz,

Just make sure that you have hidden your user form, otherwise you may not be
able to close the Print Preview.

ie.

yourUserForm.Hide

or

Unload yourUserForm

Do this before passing the .PrintPreview command.

Enjoy.

Paul.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2010, background images do not appear in print preview nor print 0
Print order of TriFold - Publisher 365 0
how can i use form/skjema tool for meny list spred in dif arks 0
Scroll does not show preview 0
Print Preview 1
Question about named area 1
Office JS api to handle redo/undo , delete event for content control class 0
Printing from Preview Screen 0

Top