View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Contol toolbox command button

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?