View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
matelot matelot is offline
external usenet poster
 
Posts: 72
Default dynamic max and min for scroll bar

Is it possible to set the min and max scrollbar to be dynamic? Everytime I
put in the properties window min "=A1" it is giving me a syntax error. I also
tried with name range and it's giving me the same syntax error. I want the
min and max to change based on selected set of data.

Thanks