Hi,
I have created a userform in a workbook named some 'x'. I made the userform to run automatically when this 'x' workbook opens by giving application.visible= false and userform.show.
I am validating some data in this user form using command buttons. Finally i want to open a validated workbook which will be created in the same location of the 'x' workbook. I kept a command button as open validated file and opened the validated file. But i dont want to close it. I just want to remain it opened and close only the user form and the 'x' workbook.
Even after closing the 'x' workbook i want the validated file to be opened only.
Please advise. Your comments are really appreciated.
I have created a userform in a workbook named some 'x'. I made the userform to run automatically when this 'x' workbook opens by giving application.visible= false and userform.show.
I am validating some data in this user form using command buttons. Finally i want to open a validated workbook which will be created in the same location of the 'x' workbook. I kept a command button as open validated file and opened the validated file. But i dont want to close it. I just want to remain it opened and close only the user form and the 'x' workbook.
Even after closing the 'x' workbook i want the validated file to be opened only.
Please advise. Your comments are really appreciated.