I wouldn't use OptionButtons. I'd just use plain old buttons from the Forms
toolbar.

I'd create macros for each of the first 3 buttons (just like you did for the 4th
button). Then assign each of the macros to the correct button on the worksheet.



TUNGANA KURMA RAJU wrote:

I would like to make a index w/sheet with option buttons to navigateto other
w/sheets , to open user forms and to run macros.for example;
option button1.--goto w/sheet 10
option button2.--goto w/sheet 6
option button3.-- open userform1
option button4.-- run macro1
Is it possible ?
If so how to put optionbuttons on w/sheet and assign functions to them?
Thannks to all mvps and excel experts in advance.

--

Dave Peterson