Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved
Is there a macro that will always open a workbook on a designated
worksheet regardless of what sheet the file was saved on when last visited? I would like to always open the workbook on Sheet1 if the value of Sheet1!A10. Thanks for any help. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Always open a workbook on Sheet1 regardless of sheet viewed when last saved
Private Sub Workbook_Open()
With Me If .Worksheets("Sheet1").Range("A1").Value 0 Then .Worksheets("Sheet1").Activate End If End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- __________________________________ HTH Bob "Michael Lanier" wrote in message ... Is there a macro that will always open a workbook on a designated worksheet regardless of what sheet the file was saved on when last visited? I would like to always open the workbook on Sheet1 if the value of Sheet1!A10. Thanks for any help. Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Always open a workbook on Sheet1 regardless of sheet viewed whenlast saved
Thanks Bob. It works just as I had hoped.
Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 excel workbook cannot be viewed unless in full screen | Excel Discussion (Misc queries) | |||
Macro to return user to previously viewed sheet | Excel Programming | |||
Update sheet1 with Data sheet in same workbook | Excel Programming | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
copy sheet1 from all open workbooks to one workbook | Excel Programming |