I am having a problem with a macro that I have develop; Scenario; I want the two macros to open a specific sheet from the same file irrespective of wether the file is closed or open. My macro's are in a file called " KPI Control Scadule" and I have assainged TWO buttons for that to open sheets within a file called "Manu Productivity Chart". My macros for each buttons are as follows: Macro1 Sub goto1() ' ' goto1 Macro ' Goto manufacturing throughput KPI charts ' ChDir "G:\Common\KPI Group\Supply Chain KPI\Group KPI" Workbooks.Open FileName:= _ "Manu Productuvity charts.xls" Sheets("Units Throughput").Select Range("B1").Select End Sub Macro2 Sub goto2() ' ' goto2 Macro ' goto unit per labour hour KPI graphs ' ChDir "G:\Common\KPI Group\Supply Chain KPI\Group KPI" Workbooks.Open FileName:= _ "Manu Productuvity charts.xls" Sheets("Units per labour hour").Select Range("B1").Select End Sub Can someone help me to make both the macros dynamic so that the irrespective of the file being open or closed the two macro button should take the user to the specific "sheet" within the "Manu Productuvity charts.xls at any time.

Hasan... You might have better luck if you posted your question on the Office Software Forum Good luck!