Excel 2003: make a cell "float"
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
--
Wales - the land of fire breathing dragons and rugby playing wizards.
"FSt1" wrote:
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.
|