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!