Probably due to an error in the macro syntax. Post you coding efforts here
by copy/paste. I suggest using a button from the forms toolbar or a shape
from a the drawing toolbar instead of a command button.

--
Don Guillett
SalesAid Software

"Shax" wrote in message
...
tried that RJ and it says - run time error '1004' and that it failed -
:( any
idea wot im doing wrong????
can u give me an example of wot the workbook name cud be?? its a case of -
the actual file name and the sheets from 1 to 9 all i need is to be able
to
click the buttons to go to the relevant pages??