Is it possible

[Greg]

Just wonder if i could get a page to automatically put a page in a workbook
and create a command button to link to it.

let say

i save a page called hotel

i would like it added to a workbook and on sheet 1 i have a command button
link to it


and show the name on the button

Is this possible

Thanks in advance

Sorry about the cross post

Greg

 

[Tonhao]

1 - Create a commnd button
2 - Add a hyperlink to it

 

[Tom Ogilvy]

worksheets("Page").copy After:=Workbooks("Book2.xls").Worksheets(3)

You can see how to add a commandbutton by turning on the macro recorder
while you do it manually.

You can see how to create event code for it at Chip Pearson's site
http://www.cpearson.com/excel/vbe.htm

 

[Greg]

Thankyou for all the help again.


Greg