PDA

View Full Version : Printing Forms from macros



JayM
08-09-2006, 04:01 AM
I have created some protected forms for users but I also have a customized printing menu. This enables the users to print to different paper trays (we have several) easily without having to go CTRl P change the paper type and remember which tray is which each time.

My printing menu lists the paper trays by type.

How can I get the Printing macros to print the protected forms. If I try at the moment I get Run-time Error 4605.

Any help would be greatly appreciated.

JayM

mdmackillop
08-09-2006, 10:40 AM
I assume you can't change the setup because the form is protected. This is a similar problem to spell-checking forms, a solution for which is shown here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=388
If you need assistance, please post your code
Regards
MD