ActiveWindow to Entire Workbook

  • hey everyone,


    I've got 2 subs I use to basically hide everything and go into full screen mode and another button to undo all the hiding.



    everything has worked great, problem is we've added a navigational button that takes you to other sheets and displays the information on those sheets and sets custom scroll areas / zoomz / locked cells and protects the sheet.


    so the macro I have only reverses some of the things that get hidden because the Active Window command, hopefully that makes sense, I wanted to copy and paste the code but the excel program is on a different computer.



    Any help would be much apperciated!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!