maro to save wooksheet & open in sheet 1

[Guest]

Hi
Is there a way to save the excel file when e.g. last saved in woorkshet 20
but upon open, it will be opened in wooksheet 1.
R
vcff

 

[David McRitchie]

You need an Event macro see
http://www.mvps.org/dmcritchie/excel/event.htm

but I can't tell what you are actually asking like if there is any significance
to the first part of the your sentence.

If you always want to open "worksheet 1" upon opening the workbook then
http://google.com/[email protected]

HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm