Print Preview

I

ianripping

I am using a macro to enable the user to open the print preview mode
When they click on close, excel takes them to a programming pages, a
that is the last of the selected sheets. I would like excel to take th
user back to "Index" sheet.

Any ideas on how I do this
 
C

Charles

ianripping


Try something like this in your code. After your code has fiished i
should activate your index sheet. put it at the end of your code.

Worksheets("Index").Activate


Charle
 
Top