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)