The hyperlink is in a cell; clicking on the cell jumps to the target. The
command button is redundant, and you'd be better without it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"eye59" wrote in message
...
I am trying to set up a 'main menu' spreadsheet in a work book this
contains
command buttons ONLY which navigate to other spreadsheets within the
workbook
or other workbooks. I set up up the command buttons via the control
toolbox
command button option and inserted hyperlinks to the spreadsheets or
workbooks I want to go to. BUT when I exit design mode inthe contol
toolbox
the command buttons don't work. What am I doing wrong? This seemed so
much
easier that using the command button in the forms toolbar and creating
macros. Also when I use the command button in forms toolbar I am unable
to
change the background of the command button? I can change the font but
not
the putty background?