5 pts.
 Switching Excel Custom Views Based on Selection
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)

Software/Hardware used:
ASKED: October 14, 2008  2:09 AM
UPDATED: October 14, 2008  1:40 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _