Hi!..Does anyone have any ideas on how you would do the following?

I want to have 1 main work book (workbook 1) with only one sheet. On that
sheet I want to create 3 buttons. Button 1 creates a link/marco to open
another workbook (workbook 2) automatically when the button is clicked,
button 2 creates a link/marco to open workbook 3 automatically when button is
clicked and button 3 creates link/marco to open workbook 4 automatticall when
button is clicked

Is this even possible?

Many thanks for any help in advance!

What do you want to do ?

Copy data from that workbook or create formula links to cells in that workbook.
Are the workbooks always the same ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"engbe" wrote in message ...
Hi!..Does anyone have any ideas on how you would do the following?

I want to have 1 main work book (workbook 1) with only one sheet. On that
sheet I want to create 3 buttons. Button 1 creates a link/marco to open
another workbook (workbook 2) automatically when the button is clicked,
button 2 creates a link/marco to open workbook 3 automatically when button is
clicked and button 3 creates link/marco to open workbook 4 automatticall when
button is clicked

Is this even possible?

Many thanks for any help in advance!

sorry it was a bit unclear after i read it...basically what i need to get
going is...i need one 'main workbook' with 3 buttons on it.
Each button when pressed will navigate to another 3 other 'workbooks' i
have. (so four in total including the main one)

EG. The Main Workbook will have:
- The first button labeled 'Forex' and navigate to a 'workbook' named 'Forex'
- The second button labeled 'Commodities' and navigate to a 'workbook' named
'Commodities'
- The third button labeled 'Options' and navigate to a 'workbook' named
'Options'

i really, really appreciate this. this is the final component of my project
and it has been stressing trying to work it all out.


"Ron de Bruin" wrote:

What do you want to do ?

Copy data from that workbook or create formula links to cells in that workbook.
Are the workbooks always the same ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"engbe" wrote in message ...
Hi!..Does anyone have any ideas on how you would do the following?

I want to have 1 main work book (workbook 1) with only one sheet. On that
sheet I want to create 3 buttons. Button 1 creates a link/marco to open
another workbook (workbook 2) automatically when the button is clicked,
button 2 creates a link/marco to open workbook 3 automatically when button is
clicked and button 3 creates link/marco to open workbook 4 automatticall when
button is clicked

Is this even possible?

Many thanks for any help in advance!

Just insert hyperlinks to those files. Does it really have to be a button?

"engbe" wrote:

sorry it was a bit unclear after i read it...basically what i need to get
going is...i need one 'main workbook' with 3 buttons on it.
Each button when pressed will navigate to another 3 other 'workbooks' i
have. (so four in total including the main one)

EG. The Main Workbook will have:
- The first button labeled 'Forex' and navigate to a 'workbook' named 'Forex'
- The second button labeled 'Commodities' and navigate to a 'workbook' named
'Commodities'
- The third button labeled 'Options' and navigate to a 'workbook' named
'Options'

i really, really appreciate this. this is the final component of my project
and it has been stressing trying to work it all out.


"Ron de Bruin" wrote:

What do you want to do ?

Copy data from that workbook or create formula links to cells in that workbook.
Are the workbooks always the same ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"engbe" wrote in message ...
Hi!..Does anyone have any ideas on how you would do the following?

I want to have 1 main work book (workbook 1) with only one sheet. On that
sheet I want to create 3 buttons. Button 1 creates a link/marco to open
another workbook (workbook 2) automatically when the button is clicked,
button 2 creates a link/marco to open workbook 3 automatically when button is
clicked and button 3 creates link/marco to open workbook 4 automatticall when
button is clicked

Is this even possible?

Many thanks for any help in advance!