If you are speaking of a command button on a worksheet from the
Forms toolbar, just right click the button and choose Assign
Macro. If you are using the command button from the Controls
toolbar, right click the button in design mode and choose View
Code and put your code in that event procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eric" wrote in message
...
Can anyone advise me how can i assign a marco to the command
button

I want to make a button when the use click on that will bring
them to a
"range" - book store ( the bookmarked name)

Thanks in advance

Eric