VBA : Jump Go To Page in Print Preview Active

[Jhon Mustofa]

hi...

in Excel 2007, in Print Preview Menu, for edited reason (eg. setting margin, etc...) i want to go to Page certainty not one by one click page (Next Page), i mean in Print Preview condition, how to jump/loop in Page....like Go To Page 2,16, 100 etc...

i have problem how to easy Go To Page.....in Print Preview in active...

one of you, could you help me figure it out.with VBA/Add in....

thanks for your helping...


john m

[shg]

Please Login or Register  to view this content.

[Jhon Mustofa]

Please Login or Register  to view this content.

hi shg, after run your macro, not work "invalid outside procedure"...how can work...

[shg]

Please Login or Register  to view this content.

[Jhon Mustofa]

Please Login or Register  to view this content.

hi shg, this i want, working well,
thank you...

[shg]

You're welcome.

[Jhon Mustofa]

hi shg, would you mind, how to make message box as controller, i mean like ;
"Go to Page........(in Print Preview).

please, sir.....

[shg]

Please Login or Register  to view this content.

[Jhon Mustofa]

Please Login or Register  to view this content.

hi shg, great done.....

thank you very much...