maro to save wooksheet & open in sheet 1
 

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

maro to save wooksheet & open in sheet 1
 

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/groups?threadm=o57...0q% 404ax.com

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

"vcff" wrote in message ...
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