Jump to any page of excel sheet randomly

[blaisexena]

Hi,
I'm new here, I just to ask if this can be done in excel, because in msword the jumping of page is possible.

How this can be done in excel?

[WasWodge]

Deleted. As I think I am miss-interpreteting the question

[WasWodge]

Try the code below if you are trying to go to any page randomly on the same sheet. Change 3 to the total number of sheets.

Please Login or Register  to view this content.

[blaisexena]

Try the code below if you are trying to go to any page randomly on the same sheet. Change 3 to the total number of sheets.

Hi,
I'm only using sheet1 and sheet1 is the page I am jumping to get any image like pictures, but I already managed to get the pictures, what I want is to jump in any page of excel sheet just like what I did in msWord.

I'll try the code,

thanks

[blaisexena]

@WasWodge

I have get what I want, it points me to the other websites while searching a keyword from your code("xlPageLayoutView"),
and the other websites was not actually what I want, but part from it to get what I wanted to.

I'm now using for each statement to loop what pages I want to scan pictures of excel.

Thank you.

[WasWodge]

Happy you seem to have found a solution.
By the way

Change 3 to the total number of sheets.

is a typo. It should read

Change 3 to the total number of pages.

[blaisexena]

thank you