My project has a Summary sheet that keeps track of 1 to N Material sheets. The Material sheets are copied from templates, imported into the Summary's workbook, and named by the user at run-time from a user form.
The idea is for one workbook to contain the Summary sheet and all its Materials sheets. So there are three buttons on the form, Add a New Material Sheet, Delete a Material Sheet and Edit a Material Sheet. Add and delete work, albeit in im sure a very primitive way, but i am stuck on Edit. When the Edit combobox has the sheet to edit's name selected and rings its changed event, execution moves me to the selected Material sheet for edit, but I cannot do anything!
My untrained perception of the problem is that I'm not allowed to edit the selected worksheet because i am still in the form's process. I *think* i need to interrupt the process so that i can really change the data on the Material sheet, then transfer the result of the change back to the Summary sheet and resume the session.
Good news is that is how i originally set the project up before learning the work process was ad hoc adding and editing from the templates, iow like a batch instead of interactively, so the Material's result range copy and past back to the destination on the Summary sheet work, but I need to move them from where they are and execute them after returning from the edit.
I think my problem is I need a way to break out of the form's process once I land on the sheet to be edited, but then I need to resume the form and when I get back to the Summary sheet so the Material's details get the refreshed results.
I heard about Auto Open and Auto Close macros, but they pertain to Workbook's, not Worksheet's events. How do i seed the worksheet's open event with code that calls its close event so after the edit, execution resumes where we left off in the form back on the Summary sheet?
Sorry for the length, but i want to find out if I'm making this more complicated than it needs to be, or there is another less involved way to achieve the objective?
Thanks for your help
The idea is for one workbook to contain the Summary sheet and all its Materials sheets. So there are three buttons on the form, Add a New Material Sheet, Delete a Material Sheet and Edit a Material Sheet. Add and delete work, albeit in im sure a very primitive way, but i am stuck on Edit. When the Edit combobox has the sheet to edit's name selected and rings its changed event, execution moves me to the selected Material sheet for edit, but I cannot do anything!
My untrained perception of the problem is that I'm not allowed to edit the selected worksheet because i am still in the form's process. I *think* i need to interrupt the process so that i can really change the data on the Material sheet, then transfer the result of the change back to the Summary sheet and resume the session.
Good news is that is how i originally set the project up before learning the work process was ad hoc adding and editing from the templates, iow like a batch instead of interactively, so the Material's result range copy and past back to the destination on the Summary sheet work, but I need to move them from where they are and execute them after returning from the edit.
I think my problem is I need a way to break out of the form's process once I land on the sheet to be edited, but then I need to resume the form and when I get back to the Summary sheet so the Material's details get the refreshed results.
I heard about Auto Open and Auto Close macros, but they pertain to Workbook's, not Worksheet's events. How do i seed the worksheet's open event with code that calls its close event so after the edit, execution resumes where we left off in the form back on the Summary sheet?
Sorry for the length, but i want to find out if I'm making this more complicated than it needs to be, or there is another less involved way to achieve the objective?
Thanks for your help
