Excel 2003: make a cell "float"

  • Thread starter Thread starter slbeersmiller
  • Start date Start date
S

slbeersmiller

Hi, I am trying to set up an interactive inventory list. I want to include a
hyperlink that takes you back to the top of the page, but I don't want to
have to place "Back to top" in several different locations. I would like it
to "float" or move up and down automatically. Is this possible? If it is,
can someone please give me step by step instructions in plain English, as I
am not a computer guru. Thanks in advance for you help.
 
hi
cells can't "float" but a text box can. but to "float" the text box would
require some spiffy relocation code. i see 2 simple alternatives
1. freeze panes on your column headers. when you want to go back to the top,
click in the headers, hit the arrow down key and your at the top again.
2. a custom icon on the menu bar with this code
sub gototop()
range("A1").select
end sub
click the icon, you're back at the top. the icon would always be visible.

regards
FSt1
 
You kindly helped on the macro code. How do you in Excel 2007 create a
Radio button that you can attach the code to in your response to
slbeersmiller.

Step by step instructions for a novice would be helpful.

Many thanks if you can assist
FinanceGuru
 
Thanks for the help!

Could you please explain to me how to do both of the things you suggested.
It would be greatly appreciated.
 
Back
Top