View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Change OptionButton true/false status on all sheets

I was asking about chart sheets--not worksheets with charts. Same thing with
macro sheets--not sheets with macros. These are different things.



Fan924 wrote:

On Sep 18, 5:33 am, Dave Peterson wrote:
Are all the sheets in the workbook worksheets--no chart sheets, no macro sheets.


Hi Dave, there are charts and macros on all sheets.

Do all the worksheets from 2 to the last have Optionbuttons by those names?


Yes. the names OptionButton1, OptionButton2, OptionButton3, are the
same on all sheets. Are there changer I can make to make this work?


--

Dave Peterson