Good morning all,
Can someone tell me if it is possible to pass variables between workbooks. What I need to do is...
I have a workbook that when a link is clicked opens up another workbook and goes to a specific sheet, however I want to be able to hide all the other sheets. The only way I can think of doing this is by passing somesort of variable to the new workbook so that it knows which sheet not to hide.
Many thanks for your assistance.
Jack.