This content has been marked as final.
Show 3 replies
-
1. Re: Worksheets in Sheet Selector Not Resizing Properly
Peter Fakan May 17, 2018 3:01 PM (in response to Ravi Mehta)1 of 1 people found this helpfulHi Ravi,
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
Peter
-
2. Re: Worksheets in Sheet Selector Not Resizing Properly
Ravi Mehta May 18, 2018 2:13 PM (in response to Peter Fakan)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.
-
3. Re: Worksheets in Sheet Selector Not Resizing Properly
Peter Fakan May 20, 2018 3:11 PM (in response to Ravi Mehta)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.
HTH
Peter