Print Preview
 

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

--
Message posted from http://www.ExcelForum.com

Print Preview
 

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

--
Message posted from http://www.ExcelForum.com