View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR[_2_] CLR[_2_] is offline
external usenet poster
 
Posts: 28
Default 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