Jellybean Cowboy
New Member
- Joined
- May 27, 2004
- Messages
- 10
Hi there,
I'm having problems with quite a complex workbook that I have created. I've designed a "font-end" based on forms and when the workbook opens the "welcome" form is visible but the workbook gets minimised so you can't see any of the rubbish contained within it.
This works fine when there are no other workbooks open but constantly falls over when there are. I am trying to make some changes to the code to allow you to use this "program" while other workbooks are open. I'm sure this is a problem with workbook/worksheet referencing but I cannot seem to fix things. Could anyone offer some guidance as to the code I should be using for ensuring selecting, hiding, maximising, and minimising of sheets is handled correctly under these conditions?
Many thanks in advance,
Jon.
I'm having problems with quite a complex workbook that I have created. I've designed a "font-end" based on forms and when the workbook opens the "welcome" form is visible but the workbook gets minimised so you can't see any of the rubbish contained within it.
This works fine when there are no other workbooks open but constantly falls over when there are. I am trying to make some changes to the code to allow you to use this "program" while other workbooks are open. I'm sure this is a problem with workbook/worksheet referencing but I cannot seem to fix things. Could anyone offer some guidance as to the code I should be using for ensuring selecting, hiding, maximising, and minimising of sheets is handled correctly under these conditions?
Many thanks in advance,
Jon.