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