1 of 1 people found this helpful
For sheet swapping to work, you need to have a value inside either a column or a row. It doesn't matter what it is, so I've just inserted " ".
HTH 2018.1 attached
Thanks a lot! Sorry, I am being a bit thick, but this still isn't working for me. I took the twbx you created for me, and if I simply remove the workbooks and try to put it back in, the sheet swapper stops working.
I'd check if the filters were cleared when you took the sheet off the workbook - you might need to re-enable them when you re-insert the sheet into the workbook again.