Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro
I have a 50 worksheet excel file. and in each of the sheets there is a
dropdown menu which has categories for that worksheet and when you click on it it takes you to that page of that particular worksheet. All of the 50 fifty worksheet is identical except the numbers which are updated monthly. Now what i want is that when ever i open the file i want each work sheet to be on the first page/ or make the first selection in the drop down menu for each work sheet.( which takes it to the first page ). How can I do that ? I am not much of a programer so help me how to write a macro for that thanks a zilllion in advance |
#2
|
|||
|
|||
I'm not quite sure I understand the question.
But are you asking how to make sure that A1 is in the top left corner of each worksheet each time you open the workbook? If yes, you can try this code: Option Explicit Sub auto_open() Dim wks As Worksheet Application.ScreenUpdating = False For Each wks In ThisWorkbook.Worksheets Application.Goto wks.Range("a1"), scroll:=True Next wks Worksheets("Sheet1").Select Application.ScreenUpdating = True End Sub Change this Sheet1 in this line: Worksheets("Sheet1").Select to the worksheet name that you really want to start on. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Urgent wrote: I have a 50 worksheet excel file. and in each of the sheets there is a dropdown menu which has categories for that worksheet and when you click on it it takes you to that page of that particular worksheet. All of the 50 fifty worksheet is identical except the numbers which are updated monthly. Now what i want is that when ever i open the file i want each work sheet to be on the first page/ or make the first selection in the drop down menu for each work sheet.( which takes it to the first page ). How can I do that ? I am not much of a programer so help me how to write a macro for that thanks a zilllion in advance -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |