I thank the three of you for your help. While your information moved me in the right direction and helped me understand the process better, the learning curve, atleast for me, is high and it created more questions than answers.

Rory and Kapers gave me confidence that what I want to do can be done. Kapers examples were informative but up to now my use of the form button and shapes have met with limited success. I think that the biggest problem that I am having being a beginner at any programing,... and an aging fart as well, is finding clear documentation that shows all of the command structure purmutations.

I managed to get the original code to attach to an activex button will little trouble. It works as expected... HT Rudi

My ultimate goal is to use shapes as buttons as I have already successfully used them for a couple other functions on the same spreadsheet and would like a consistant look.
Shapes of course look better and have more visual flexibility.

When attempting to use the form button, I had to rewrite the code as I could not get the event (hiding or unhiding rows) to trigger off of the text contained in the button. I managed to change the text by using the status of the rows as the trigger. It operates but the reason I wanted to use the text as the IF trigger is to cause other actions that may not have any relation to the state of the rows

>>>>>>>>>>>>>>>>
If Range("10:20").EntireRow.Hidden = True Then
Range("10:20").EntireRow.Hidden = False
ActiveSheet.Buttons(1).Text = "Hide US Register"

Else

Range("10:20").EntireRow.Hidden = True
ActiveSheet.Buttons(1).Text = "Show US Register"

End If

>>>>>>>>>>>>>>>>>>>>>>>>>>>

Using shapes I could only manage to write something that would cause the rows to hide or reveal but could not effect the text at all..

If you could nudge me forward with more words of wisdom and perhaps some example I would appreciate it.

Regards

Scott