Good afternoon happy campers,

I have a sheet with hyperlinks on (that work fine) only i want to replace the hyperlink with a button (button/command button)
I have tried adding a command button, then right clicking, selecting 'View Code' than adding my hyperlink in, but it says compile error: Syntax error.

The hyperlink i have added is a network file, 
ThisWorkbook.FollowHyperlink Address:=W:\Main folder\sub folder\sub folder\name of sheet.xls
Anyone kind enough to point me in the right direction?

kind regards, galvinpaddy