May be easier to have one macro and one button using a drop down to a
worksheet_change event for the cell of the dropdown.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Iraj" wrote in message
...
Hi all:
I have made a daily report sheet for a company which has different
projects
and different information. Instead of typing all that repeatedly, I prefer
to
assign few active buttons beside this report sheet that when you click
each
buttons all its related information appears in the header of that
project's
form. (E.G 5 buttons where on each written the name of respective project,
when I click on that all its related information such as address and
others
appears on the header of the report and so on). Is it possible by
Macro(VBA).
I appreciate if some one helps.