Advice please
 

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

Greg

Are you saying you want to open a new work book
click on a button & have an extra blank sheet called hotel? or is hotel a
sheet that is full of information that you want to bring into a new work book
when requried?
Cheers
peterm

"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

Greg

I managed to work it out I made excel do the work for me. I used a macro to
type it for me when needed as I would be using the same names in different
workbooks.

Thanks for the help anyway

Greg