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

"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.

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.

hi
not up on 2007 yet, still stuck on 2003 here/
i don't recomend a radio button. custom icons would be better.
see these site. good site. snoop around if you want to learn 2007
http://www.rondebruin.nl/qat.htm
http://www.rondebruin.nl/ribbon.htm

regards
FSt1

"Finance Guru" wrote:


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.

Hey thanks a bundle.

--
Wales - Where once miners toiled,now fire breathing dragons and rugby
playing wizards play in lush green valleys.


"FSt1" wrote:

hi
not up on 2007 yet, still stuck on 2003 here/
i don't recomend a radio button. custom icons would be better.
see these site. good site. snoop around if you want to learn 2007
http://www.rondebruin.nl/qat.htm
http://www.rondebruin.nl/ribbon.htm

regards
FSt1

"Finance Guru" wrote:


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.

Thanks for the help!

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




"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.