Hello everyone, I have a workbook and the first sheet is an index to go to other sheets in the same file, each sheet is a form.
The info for those forms is in different workbooks, so what I need is a macro to open a certain workbook when a certain sheet is selected, keep it hiden and close it when user hits a send button.
Can anyone assist?
Thanks much in advanced.
Sebastian
The info for those forms is in different workbooks, so what I need is a macro to open a certain workbook when a certain sheet is selected, keep it hiden and close it when user hits a send button.
Can anyone assist?
Thanks much in advanced.
Sebastian