0

I have 5 sheets. The 5th is made of a bunch of macros that use data from 1 to 4.

I want to hide 1 to 4 but then the macros in the fifth don't work because they can't 'see' 1 to 4.

Have I actually hit an limitation of excel ?

J.C
  • 252
  • 5
  • 18
  • 3
    No, it's not a limitation of Excel. If you want more help, please show your code. – RADO Feb 07 '20 at 01:45
  • If your code includes commands like `Select` or `Activate` they won't work on hidden sheets. Take them out. You can access any part of any sheet, hidden or not, without selecting anything. – Variatus Feb 07 '20 at 01:47
  • I do use `Sheets("sheet-name").select`. What would be the alternative? – J.C Feb 07 '20 at 01:50
  • `https://stackoverflow.com/questions/38859482/excel-2013-vba-alternative-to-using-activate-and-select` full path to datapoint explain in here seem to be the way – J.C Feb 07 '20 at 01:56
  • 4
    [This](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba) very popular question should help. Without seeing your code, your'e not likely to get anything more specific really – urdearboy Feb 07 '20 at 02:51

0 Answers0