View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Excel 2003: make a cell "float"

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

"slbeersmiller" wrote:

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.