how to enable print function ?

[vumian]

dear all,

i put this code to thisworkbook to disable print function

Please Login or Register  to view this content.

now, i wanna click on command button to enable print fucntion as normal

Thanks in advance

[dominicb]

Good afternoon vumian

Something like this should help :

Please Login or Register  to view this content.

HTH

DominicB

[mikerickson]

In normal module

Please Login or Register  to view this content.

In ThisWorkbook

Please Login or Register  to view this content.

[vumian]

hi all,

cld you upload exampling file,

Thank you very much

[vumian]

thanks all, i did successfully

[vumian]

dear all,

i wanna allow the printPreview thro my code is putting workbook_beforeprint inside

Thanks in advance

[dominicb]

Hi vumian

i wanna allow the printPreview thro my code is putting workbook_beforeprint inside

Not sure what you mean.
Could you expand a little?

DominicB

[vumian]

OK, follow this code

Please Login or Register  to view this content.

I wanna click on PrintPreView, i wanna the msgbox does not appear
May it help you understand me

Thanks in advance

[dominicb]

Hi vumian

I wanna click on PrintPreView, but msgbox does not appear

The code works fine for me when I Print Preview.
Where have you put the code? It needs to go in the ThisWorkbook module - this is where you have put it isn't it?

HTH

DominicB

[vumian]

i wanna the msgbox does not appear

[mikerickson]

The Before_Print event occurs both with Print and PrintPreview. Code can't distinguish between them. This routine cancels both Print and PrintPreview and replaces them with the PrintPreview dialog. It can be controlled with the OKtoPrint variable in the same way as the Cancel both routine posted above.

Please Login or Register  to view this content.

[vumian]

No solution to get that 2 buttons into 2 parts separate ?

[mikerickson]

Disabeling Excel's Print also disables PrintPreview.

Rather than fiddling with the Before_Print event, you could disable both Excel's Print and PrintPreview and replace them with your own PrintPreview button and a (password protected?) Print.

One other question, if Print is disabled, why would the user want to Preview the Print they can't do?

[mikerickson]

All three of these routines assume that this is in the ThisWorkbook code module.

Please Login or Register  to view this content.

Each of these routines can be assigned to a button from the Forms menu.

togglePermission will only run when called by a command button. When permission is denied, neither normal Excel Print nor PrintPreview will work.

myPreview will display a PrintPreview, regardless of the status of the permission.

PrintWithPassword will print (if permission allows) or ask for a password to overide permission.

This goes in a normal module.

Please Login or Register  to view this content.