Hello,
First, just let me say that this is my first post here, and any assistance is greatly appreciated. I'd prefer tips, rather than a copy & paste fix
I'm working on a pretty simple code, but I'm completely boggled. My VBA knowledge is pretty limited, so I know that it's blatantly obvious what I am doing wrong, but I have been looking at it for too long to notice the error for myself . A quick forum search yielded little pertinent info, so I come here begging for help.
I want my worksheet to require validation of entry data before printing, so I decided to use the "Workbook_BeforePrint" event, and display a simple dialog box with an "ok" or a "cancel" button as input options.
The problem is that, as coded, "cancel" button does not cancel the print.
Here is the sample code:
Workbook_BeforePrint:
UserformPlease Login or Register to view this content.
Thanks in advance for any assistance! I look forward to hearing from you.Please Login or Register to view this content.
Bookmarks