No problems when assigning the hyperlink, but when I click it I get an error
"Cannot open specified file"

"Gary''s Student" wrote:

Put ANY piece of ClipArt on the worksheet. (if you like buttons, use a
rectangle from AutoShapes)

Right-click the Object and pick Hyperlink from the resulting menu.
--
Gary''s Student - gsnu200830


"Mike K" wrote:

Oh Wise Ones,
I have been searching old posts and cannot find
something that works for me. I would like to assign a hyperlink to another
sheet to a button. It was suggested to use the Follow Hyperlink event, but
it does not show up as an assignable macro. The command button click event
would not allow me to get to click mode on the button- always had crosshairs.
Obviously I'm doing something wrong, and some help would be much
appreciated.

1) Place a button on the worksheet.
2) click on it
3) takes me to:
HYPERLINK("file:S:\common\Lab\DataSheets\Asphalt\F iller\Filler%
Datasheet.xls" (not sure if the syntax is right, its what I use in a
cell)

Thanks,
Mike