View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TBoe TBoe is offline
external usenet poster
 
Posts: 3
Default Programming a Command Button

I have a rather large spreadsheet and I want to program a command button that
would bring up the "go to" box that already has alphabetical references. I
realize the "Ctrl G" is the shortcut but I also would like the button and
place it in a freeze pane so it's always visible. I really don't know VBA.
I tried creating the command button and record a macro but it didn't work.
Any ideas would be greatly appreciated. I really wanted to make command
buttons for each letter of the alphabet and have it hyperlink to the
respected reference. I'm not sure how to do that either. What's the better
an easier way?
Thanks for your help.
Terry