zjnz

welcome to my space

Control Printing

January 06th, 2009 | Category: zjnz.com
  • I have a custom menu with custom printing. I don't want the user to use Excel's default printing (File-Print, the Print button or Ctrl+P)
    I don't want to disable the options, I just want a warning to popup.
    I had set up the BeforePrint Event except it also pops up the warning when using my custom printing.
    How can I capture those specific actions that I want to warn?
    I saw something about .onaction, but I'm not sure.
    help?


  • yup, did the job - thanks


  • I haven't done this myself, but others have documented their success with the method. Link the default XL menu item/shortcut/commandbutton to your own routine which displays the warning and then, if appropriate, calls the XL dialog with Dialogs(xlDialogPrint).Show method.


  • Howdy Starl, maybe I'm not following, but, you can keep your before print event and simply disable events with your custom print procedures. Probably want to reenable them as well. Here's an example:

    Sub test()
    Application.EnableEvents = False
    ActiveSheet.PrintOut
    Application.EnableEvents = True
    End Sub

    Hope this helps.


  • hmm - that *would* work, wouldn't it...
    I just need to figure out exactly when it's figuring I want to print..

    thanks - I look into it this weekend.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Control Printing , Please add it free.
    edit

    Mexico