Ok Izandal I can create the module like you suggested, and are you saying to put the application.run code into the buttonclick command?
I click the debug on the error code. I attached a picture of the code it highlighted.
It highlighted the application.run code...
What is code to open other workbook? Will it be OK to allow user to close this workbook and then have userform reappear automatically?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
How would it know "when" to reappear? Because the user will be working in the workbook or worksheet and when they are finished they would click button to get back to form. So how would VBA/Windows/Excel know when that is?
Not sure how that would work.. How owuld it know when to open the form?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks