GOTO another sheet
Hi All..........
I have a cell E41 on Sheet1, with a validation list drop-down. One of the
selections on the list is "Custom". Is it possible that whenever that
selection is made that another sheet called "GraphicsForm" could be made
active instead of Sheet1?.....and then when work is done on the
"GraphicsForm" sheet and the user switches back to Sheet1, it will stay
there and not automatically go back to "GraphicsForm" sheet again,
until/unless E41 is changed away from "Custom" and then changed back again
to "Custom".?
TIA
Chuck, CABGx3
|