ldench
09-25-2008, 12:55 AM
Hi All,
I have a problem, looking for some help. I'll break it down in steps so its easier to read.
I have Userform (saveform) in my workbook.
Saveform has a save button on it where it will save the workbook using a predetermined name.
I want the saveform to show when the user tries to save (either save or save as)
That all works fine, only problem is that every time they click the save button on the saveform, the workbook_beforesave kicks back in and it reopens the form, which is still open from before, so it crashes my excel.
I need workbook_beforesave to be exited once they click the save button on the userform, is this even possible?
Thanks
Lee
I have a problem, looking for some help. I'll break it down in steps so its easier to read.
I have Userform (saveform) in my workbook.
Saveform has a save button on it where it will save the workbook using a predetermined name.
I want the saveform to show when the user tries to save (either save or save as)
That all works fine, only problem is that every time they click the save button on the saveform, the workbook_beforesave kicks back in and it reopens the form, which is still open from before, so it crashes my excel.
I need workbook_beforesave to be exited once they click the save button on the userform, is this even possible?
Thanks
Lee