Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't paste in excel without having an open excel sheet! | Excel Discussion (Misc queries) | |||
Open the file or save it - missing | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
How to open a spreadsheet on a named sheet from a hyperlink? | Links and Linking in Excel | |||
need to save MS Excel sheet to open in Excel for Mac | Excel Discussion (Misc queries) |