J
Jim A
Hi -
Can somebody help me with a drop down menue macro.
I have a list of names on a hidden worksheet, Sheets("Student Info"), which
the drop down menue lists those names.
The drop down menue is on another, Sheets("Sheet1")
When I choose a student name from the drop down menue, I would like several
previously saved worksheets to open in the original workbook.
When another name is selected, I would like the students worksheets that
were opened to be saved (with a date and time stamp), closed, and the new
worksheets of the new student opened.
Thanks for your help - Jim Ayers
Can somebody help me with a drop down menue macro.
I have a list of names on a hidden worksheet, Sheets("Student Info"), which
the drop down menue lists those names.
The drop down menue is on another, Sheets("Sheet1")
When I choose a student name from the drop down menue, I would like several
previously saved worksheets to open in the original workbook.
When another name is selected, I would like the students worksheets that
were opened to be saved (with a date and time stamp), closed, and the new
worksheets of the new student opened.
Thanks for your help - Jim Ayers