T
Tony Bender
My application consists of two workbooks. The first is my menu which
has one sheet with a button that when clicked opens a UserForm (UF3).
From this the user makes a selection from a ListBox (LB1), then makes
one selection from several different OptionButtons. The selected
OptionButton populates a second ListBox (LB2). The user makes a
selection from LB2 and finally clicks on a CommandButton (CB1) which
retrieves and opens the second workbook.
Private Sub CB1_Click()
Workbooks.Open "C:\Data\Library\Report.xls"
Sheets("report").Select
Range("A1").Select
Unload UF3
End Sub
This works fine, but where I have problems is writing code enabling
the user to return to the UF3 to change one or more selections.
What I want to do is:
1. Add a button to the Report sheet so the user can return to the
UserForm and change one or more selections, but keep the Report.xls
file open in the background.
2. Have the UserForm maintain their previous selections so they don't
have to start the process from scratch.
3. Upon their second wave of selections since the Report.xls is
already open, write the code so the user won't be alerted about re-
opening a file that is already open, and being in a 'read-only' mode.
I've been trying all sorts of code but nothing is working
I am working in Excel 2003.
Thank you for any direction with this.
has one sheet with a button that when clicked opens a UserForm (UF3).
From this the user makes a selection from a ListBox (LB1), then makes
one selection from several different OptionButtons. The selected
OptionButton populates a second ListBox (LB2). The user makes a
selection from LB2 and finally clicks on a CommandButton (CB1) which
retrieves and opens the second workbook.
Private Sub CB1_Click()
Workbooks.Open "C:\Data\Library\Report.xls"
Sheets("report").Select
Range("A1").Select
Unload UF3
End Sub
This works fine, but where I have problems is writing code enabling
the user to return to the UF3 to change one or more selections.
What I want to do is:
1. Add a button to the Report sheet so the user can return to the
UserForm and change one or more selections, but keep the Report.xls
file open in the background.
2. Have the UserForm maintain their previous selections so they don't
have to start the process from scratch.
3. Upon their second wave of selections since the Report.xls is
already open, write the code so the user won't be alerted about re-
opening a file that is already open, and being in a 'read-only' mode.
I've been trying all sorts of code but nothing is working
I am working in Excel 2003.
Thank you for any direction with this.