creating three buttons to display page 1, page 2 and all pages of sheet 1 (excel file)

Question

I have a worksheet in an excel file (Office 365) consisting of two pages in (sheet 1). I want to create three&nbsp;buttons as described below:button 1: to display page 1 of sheet 1 only.button 2: to display page 2 of sheet 1 only.button 3: to display all (Pages 1 &amp; 2) of sheet 1.&nbsp;I do not know how can I do it. Hope to help me to do this issue.&nbsp;&nbsp;Regards

nikolinode · Answer

ajl_ahmed&nbsp;So you could generate page previews for each individual sheet...insert code in a VBA button.&nbsp;&nbsp;Option Explicit

Sub Print_Preview()
With ActiveSheet.PageSetup
ActiveWindow.SelectedSheets.PrintPreview
'ActiveSheet.PageSetup.PrintArea = "A1:AH60" 'only if you like to see only specific area

End With

End Sub&nbsp;&nbsp;

Forum Discussion

creating three buttons to display page 1, page 2 and all pages of sheet 1 (excel file)

I have a worksheet in an excel file (Office 365) consisting of two pages in (sheet 1). I want to create three buttons as described below:

button 1: to display page 1 of sheet 1 only.

button 2: to display page 2 of sheet 1 only.

button 3: to display all (Pages 1 & 2) of sheet 1.

I do not know how can I do it. Hope to help me to do this issue.

Regards

Share

Resources