Printing-But not showing the page
 

You folks have been great in helping me out to learn how to use VBA Code.
Not sure if what I need help on now, is VBA code or something that I can do
just from Excel, but here goes my question.

I have a VBA print button on say my Input Page sheet. This button is
pressed after information is completed in the above form. What currently
happens is the page that pulls information from my Input Page sheet, flashs
on the screen for a second or two. What I would like to have happen is that
sheet NOT to show even though the print button has been pressed. What I
would like to see, while this process is being printed is just my Input Page
sheet.

Steve

Printing-But not showing the page
 

do you have screen updating turned off?



application.screenupdating = false
'code
application.screenupdating = true



not be sure to turn it back on!!
include the the turn back on in any error trapping you have
ben




--
When you lose your mind, you free your life.


"caldog" wrote:

You folks have been great in helping me out to learn how to use VBA Code.
Not sure if what I need help on now, is VBA code or something that I can do
just from Excel, but here goes my question.

I have a VBA print button on say my Input Page sheet. This button is
pressed after information is completed in the above form. What currently
happens is the page that pulls information from my Input Page sheet, flashs
on the screen for a second or two. What I would like to have happen is that
sheet NOT to show even though the print button has been pressed. What I
would like to see, while this process is being printed is just my Input Page
sheet.

Steve

Printing-But not showing the page
 

Ben,

That was the answer. Thanks didn't even know about the Screen Updating
option.

Steve

"ben" wrote:

do you have screen updating turned off?



application.screenupdating = false
'code
application.screenupdating = true



not be sure to turn it back on!!
include the the turn back on in any error trapping you have
ben




--
When you lose your mind, you free your life.


"caldog" wrote:

You folks have been great in helping me out to learn how to use VBA Code.
Not sure if what I need help on now, is VBA code or something that I can do
just from Excel, but here goes my question.

I have a VBA print button on say my Input Page sheet. This button is
pressed after information is completed in the above form. What currently
happens is the page that pulls information from my Input Page sheet, flashs
on the screen for a second or two. What I would like to have happen is that
sheet NOT to show even though the print button has been pressed. What I
would like to see, while this process is being printed is just my Input Page
sheet.

Steve