Thread: Command Button
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gee-dope Gee-dope is offline
external usenet poster
 
Posts: 1
Default Command Button

OK that was too stupid...I had it in design view.
That worked, by the way!
Thanks.
-----Original Message-----
Now it's not letting me push the button...any

suggestions?
Do I have to convert to a form or something?
Sorry I'm so ignorant.

-----Original Message-----

Sheets("24").Activate ' Excel doesnt allow numbers for

sheetnames!
So
Sheets("Sheet24").Activate


----- Gee wrote: -----

I'm real new at programing in Excel...Access I've

done.
I need to know the "on click" code for a command

button to
open a spreadsheet in a workbook. I've got a table

of
contents and I want to be able to click the button

to go
to the proper sheet within that book. Say the

sheet
is
named 24.
Thank you in advance for your help.
Gee

.

.