I have two Optionbuttons on a worksheet when you click one it enables certain
commandbuttons on the same sheet and changes the interior color and locks
certain cells, then you click another commandbutton and it runs a macro
creating a new sheet. After the new sheet is created you can then click on a
command button on the new sheet and it will bring you back to the first
sheet. When I click on the second optionbutton, it is supposed to disable the
commandbuttons that were enabled, then change the interior color and unlock
the cells that were locked, however it will not release the last
commandbutton it disables and select the cell that I have told it to. I get
an error message that says 'Object doesn't support this property or method'.
When I look at the sheet the last commandbutton is still selected. If I
manually select the cell then click continue the macro finishes. Any
suggestions?