Have workbook open to default optionButton

[zplugger]

Looking for a way to have workbook open to optionbutton5 if the workbook name is Price Example ActiveXv2,if not then open workbook to how
it was saved.?
Thanks for suggestions Z

[davesexcel]

Please Login or Register  to view this content.

[zplugger]

Thanks davesexcel,almost there. It does set the option button right but sheet one is not update until you do sheet change. My default it will open to
sheet1,so is it possible to have it set right on open. The Price Example using ActiveX v2.xlsm in upper post show better.

Thanks

[zplugger]

Maybe I'm going at this the wrong way, looking for any suggestions.

Thanks Z

[davesexcel]

I don't know what your asking, put the code anywhere you want.

[zplugger]

Thank You
This part of the code works perfect,but it will not update sheet1 with correct data.On the sheet with optionbuttons there is a commandbutton to run this code to update sheet1.

Please Login or Register  to view this content.

Here is update code,tried to add to workbook open with no luck.

Please Login or Register  to view this content.

need a way to click the button on open,not sure how to do this?.

Thanks Z

[zplugger]

added a welcome button on sheet 1 but it will not run the code from sheet1,runs from products sheet?

[davesexcel]

Try this,

Please Login or Register  to view this content.

[zplugger]

Thanks davesexel works Perfect.
Z