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

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

"Greg" wrote:

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

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

--
Regards,
Tom Ogilvy



"Greg" wrote in message
...
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

Thankyou for all the help again.


Greg