blackie42
11-21-2016, 08:05 AM
Workbook is called 'Transfers' and has several tabs that need reformatting, example tab named 'Bank'
The code for reformatting Bank tab (called Reformat1) has been done and works, code is in another separate spread-sheet called
ReformatBank - i.e. as long as WB called 'Transfers' is open and the tab named 'Bank' is visible the code runs and
formats as needed.
I really need a button on the ReformatBank WB that checks to see if the WB Transfers is open and then uses the Reformat1 code to
sort the bank tab as needed.
Any ideas as to how to link the 2 books together.
thanks
Jon
The code for reformatting Bank tab (called Reformat1) has been done and works, code is in another separate spread-sheet called
ReformatBank - i.e. as long as WB called 'Transfers' is open and the tab named 'Bank' is visible the code runs and
formats as needed.
I really need a button on the ReformatBank WB that checks to see if the WB Transfers is open and then uses the Reformat1 code to
sort the bank tab as needed.
Any ideas as to how to link the 2 books together.
thanks
Jon