Hi guys,
So I have like a 15 sheet workbook and all the pages are hidden except for 1 configuration page and based of what you input on the configuration page I have a macro that will unhide the pages you need. No user will need more than say 17 pages at 1 time. However once I run the macro the pages I want unhide themselves yet when I make any change to any cell on a sheet that effects a cell on another sheet say through a formula basically all other sheets in the whole workbook randomly appear on that page in like a huge mixed up mess of other pages its very strange. This happen on every page I change a cell on and it makes using the model basically impossible. This only occurs after I run the macro and until I exist the workbook. I Turned screen updates off in the macro but nothing changed. I will attach the code below. Any help is appreciated.
Thank you so much,
Your friend.