-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
- Thread starter npiere
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
You could copy the code assigned to your print button to the Workbook_BeforePrint procedure. Then it won't matter whether the user clicks your button or prints normally.
Upvote
0
stevebausch
Well-known Member
- Joined
- May 11, 2002
- Messages
- 810
Is this about printing a "hidden" sheet?
I have also intended to force user to use a button of my design, not the stock printing routines.
That was all about printing a sheet not visible to the user, not visible to Excel.
I gave up on disabling/hiding the stock Excel icon/menu selection. Because hiding those will drive the user CRAZY.
Consider accomplishing your goal another way:
In WorkBook_BeforePrint, test for ActiveSheet.Name, or ActiveSheet.CodeName.
If user is attempting to print the "wrong" sheet, set Cancel to True, pop up a MsgBox to inform the user of the error in their ways.
The way I am now meditating on is this:
DON'T CREATE A HIDDEN SHEET, AND EXPECT TO PRINT IT WITHOUT A LOT OF GRIEF.
I asked myself the following question:
Am I using more than half the columns? No, I wasn't. Not even ten percent of columns
I am already manipulating PrintArea, if I set PrintArea to the area I am preparing/formatting, AND that area is on the visible sheet, that keeps the user, and Excel, contented, not confused.
If this sounds like a technique to investigate, let me know. I will continue with the topics of ScrollArea, and how Locked cells/Protection figure in on my plan.
_________________
This message was edited by stevebausch on 2002-10-12 11:22
I have also intended to force user to use a button of my design, not the stock printing routines.
That was all about printing a sheet not visible to the user, not visible to Excel.
I gave up on disabling/hiding the stock Excel icon/menu selection. Because hiding those will drive the user CRAZY.
Consider accomplishing your goal another way:
In WorkBook_BeforePrint, test for ActiveSheet.Name, or ActiveSheet.CodeName.
If user is attempting to print the "wrong" sheet, set Cancel to True, pop up a MsgBox to inform the user of the error in their ways.
The way I am now meditating on is this:
DON'T CREATE A HIDDEN SHEET, AND EXPECT TO PRINT IT WITHOUT A LOT OF GRIEF.
I asked myself the following question:
Am I using more than half the columns? No, I wasn't. Not even ten percent of columns
I am already manipulating PrintArea, if I set PrintArea to the area I am preparing/formatting, AND that area is on the visible sheet, that keeps the user, and Excel, contented, not confused.
If this sounds like a technique to investigate, let me know. I will continue with the topics of ScrollArea, and how Locked cells/Protection figure in on my plan.
_________________
This message was edited by stevebausch on 2002-10-12 11:22
Upvote
0
Similar threads
