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