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

ActiveSheet.PrintOut From:=2



"TG" <(E-Mail Removed)> wrote in message
news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
> >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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:E9F9039D-B91D-4108-91E9-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
>> >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
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news:E9F9039D-B91D-4108-91E9-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
>> >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
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:E9F9039D-B91D-4108-91E9-(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>>> news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
>>> >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
>>>
>>>
>>>
>

On Fri, 26 Jun 2009 11:44:01 -0700, TG <(E-Mail Removed)>
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.

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


On Fri, 26 Jun 2009 12:19:01 -0700, TG <(E-Mail Removed)>
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" <(E-Mail Removed)> wrote in message
>> news:E59EAAD4-EB6C-4AD0-9228-(E-Mail Removed)...
>> >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
>>
>>
>>