I would like to force a sub routine to run whenever the File, Print command is used on a particular sheet. Is this possilbe?
Yes, I have a custom Print button on the sheet, but the users can still select the File, Print command and print bad data.
Yes I also know I can run the sub routine whenever it the sheet is activated, but the routine takes some time and I would rather not do that.
Thanks for your help.
Excel 2000
Last edited by proepert; 05-22-2010 at 04:56 PM.
Could you not create your own menu options and toolbars, so that only your print button is available.
You could use a BeforePrint event macro in a workbook module.
This is triggered when any sheet is printed. If the specified sheet is to be printed it will run your sub, otherwise it will just print as normal.
Please Login or Register to view this content.
Re: Run sub before sheet is printed?
Thank you very much.
This works when the sheet is selected, but how can I also run the sub when the "Entire Workbook" option is selected in the Print dialog box?
Last edited by proepert; 05-21-2010 at 06:43 PM.
You could prevent people from printing the entire workbook. The code below will only allow the active sheet to be printed.
Please Login or Register to view this content.
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks