Hi
i have a data entry sheet including an interface sheet. on the interface sheet, I want to see the print preview for each sheet through clicking on the button/shape name for example
by clicking on Shape 1>> I want to see the sheet1 print preview
by clicking on Shape 2>> I want to see the sheet2 print preview
by clicking on Shape 3>> I want to see the sheet3 print preview
and so on....
Please guide me what I have to do
i have a data entry sheet including an interface sheet. on the interface sheet, I want to see the print preview for each sheet through clicking on the button/shape name for example
by clicking on Shape 1>> I want to see the sheet1 print preview
by clicking on Shape 2>> I want to see the sheet2 print preview
by clicking on Shape 3>> I want to see the sheet3 print preview
and so on....
Please guide me what I have to do