I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited in my understanding of VBA, but I have successfully copied numerous ones that I've learned on the web and then inserted them & even som elimited modifications when I have been able to decipher the parameters. Is there a simple VBA code that I could use which would allow me to choose between two saved custom views?
(Currently using Excel 2003)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!