software

Is there a way to create a quot;buttonquot; in a worksheet that will take you to
a specific place somewere else in a worksheet?

As a way to not have to scroll through a large workbook.--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: www.excelforum.com/member.php...oamp;userid=28719
View this thread: www.excelforum.com/showthread...hreadid=515388You can name the cell by clicking INSERT on the menu and selecting NAME,
DEFINE.

After the name has been defined you can press the F5 GoTo key, which will
display a list of named cells in the workbook. You can either select the
name from the list of displayed names or type the name yourself in the
REFERENCE field. Click OK and you're there.
--
Kevin Backmannquot;swissforestryquot; wrote:

gt;
gt; Is there a way to create a quot;buttonquot; in a worksheet that will take you to
gt; a specific place somewere else in a worksheet?
gt;
gt; As a way to not have to scroll through a large workbook.
gt;
gt;
gt; --
gt; swissforestry
gt; ------------------------------------------------------------------------
gt; swissforestry's Profile: www.excelforum.com/member.php...oamp;userid=28719
gt; View this thread: www.excelforum.com/showthread...hreadid=515388
gt;
gt;

Create a button on the worksheet and assign the following macro
to it:

Sub GotoRange()
Application.Goto Worksheet(quot;Sheet2quot;).Range(quot;A2quot;),True
End Sub

change the range as desired.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;swissforestryquot;
gt; wrote
in message
news:swissforestry.23n3cn_1140626410.038@excelforu m-nospam.com...
gt;
gt; Is there a way to create a quot;buttonquot; in a worksheet that will
gt; take you to
gt; a specific place somewere else in a worksheet?
gt;
gt; As a way to not have to scroll through a large workbook.
gt;
gt;
gt; --
gt; swissforestry
gt; ------------------------------------------------------------------------
gt; swissforestry's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28719
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=515388
gt;