Hi, how can I save the current workbook name for example wba when I run a sub as a variable to then be able to activate wba when the sub has activated workbook b - I always know the name of sheet b however sheet a changing and code runs from taskbar. Many thanks for your time just don't know how to save it as public or pass the argument to another sub. Essentially my code activate a named workbook and from this I need to activate the original which name changes. Code starts from original.