Solve : Macros in Excel?

1.	Solve : Macros in Excel?
Answer» is it possible for a macro to open a saved WORKBOOK depending on the VALUE of a specific cell? I have created a GUI for my spreadsheets and want it to display a specific workbook from the MENU depending on the value of a specific cell. My idea is to create a macro that when pressed compares the cell value to the workbooks and displays the corresponding workbook...Yes. May I suggest you search the many, many places where you can find samples of robust Excell macros that can almost do anything.. Here is just one of the many... http://knowledgecenter.gateway.com/index.jsp?mtr=DCYPORH0A&sg=hm Hope this helps. just wanna say THANX for that link it has helped enormously!!

Discussion