how can I print a worksheet without printing the first page?
 

I have a worksheet that I would like to print, but I would like to skip page
one all the time. I dont want the user to click print and then select what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

THanks,

I tried it but it give me a compile error: invalid outside procedure and it
highlights the number 2.. any ideas?

"JLGWhiz" wrote:

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

Without seeing the code you are trying to run, it is difficult to tell. It
worked for me on a test where I created a sheet with more than one page.
You could try using the sheet name instead of ActiveSheet.

Sub dk()]
Sheets("Sheet1").PrintOut From:=2
End Sub


"TG" wrote in message
...
THanks,

I tried it but it give me a compile error: invalid outside procedure and
it
highlights the number 2.. any ideas?

"JLGWhiz" wrote:

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select
what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

You need to put that *inside* a procedure of some kind (macro or event). I'm
sure JLGWhiz assumed you had other code controlling the print process and
wanted to add this feature to that code. Something like...

Sub YourMacroName()
'....
'.... <<Start of your code goes here
'....
ActiveSheet.PrintOut From:=2
'....
'.... <<Rest of your code goes here
'....
End Sub
--
Rick (MVP - Excel)


"TG" wrote in message
...
THanks,

I tried it but it give me a compile error: invalid outside procedure and
it
highlights the number 2.. any ideas?

"JLGWhiz" wrote:

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select
what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

Or the single line of code could be run from the Immediate window
but not a likely scenario!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Rick Rothstein" wrote in message
...
You need to put that *inside* a procedure of some kind (macro or event).
I'm sure JLGWhiz assumed you had other code controlling the print process
and wanted to add this feature to that code. Something like...

Sub YourMacroName()
'....
'.... <<Start of your code goes here
'....
ActiveSheet.PrintOut From:=2
'....
'.... <<Rest of your code goes here
'....
End Sub
--
Rick (MVP - Excel)


"TG" wrote in message
...
THanks,

I tried it but it give me a compile error: invalid outside procedure and
it
highlights the number 2.. any ideas?

"JLGWhiz" wrote:

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select
what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG

how can I print a worksheet without printing the first page?
 

On Fri, 26 Jun 2009 11:44:01 -0700, TG
wrote:


I have a worksheet that I would like to print, but I would like to skip page
one all the time. I dont want the user to click print and then select what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG
Write a script that highlights all the sheets you want to print, and
the print task then only prints those sheets in its default manner, which
is "selected".

The user can also manually highlight sheets tabs and leave out the
undesired sheet(s). The print task always defaults to the selected
sheet(s), so you can even have it skip the print dialog completely
through the script, or manually by using the print icon.

how can I print a worksheet without printing the first page?
 

Look up the help info on the "PrintOut" command.


On Fri, 26 Jun 2009 12:19:01 -0700, TG
wrote:


THanks,

I tried it but it give me a compile error: invalid outside procedure and it
highlights the number 2.. any ideas?

"JLGWhiz" wrote:

ActiveSheet.PrintOut From:=2



"TG" wrote in message
...
I have a worksheet that I would like to print, but I would like to skip
page
one all the time. I dont want the user to click print and then select what
pages to print, I would like this to be done automatically.
Can it be done?

THanks,

TG