Bookmarks on Sheet

I have a sheet which is quite long. I need to create links, or a drop-down menu of some sort, which can select different points in the same sheet. So, if i click "Bookmark 4", it will scroll/direct the page to a certain point in the sheet.

Originally Posted by aposatsk

I have a sheet which is quite long. I need to create links, or a drop-down menu of some sort, which can select different points in the same sheet. So, if i click "Bookmark 4", it will scroll/direct the page to a certain point in the sheet.

Hi aposatsk,

Try View > Custom Views, then select your range of cells and give then a meaningful name for your view

oldchippy

Okay. That is a step closer. But can i make the "Views" in Custom Views show up costantly on some toolbar or in a cell?

Originally Posted by aposatsk

Okay. That is a step closer. But can i make the "Views" in Custom Views show up costantly on some toolbar or in a cell?

Record a macro in this workbook to select your named view, then create a new Toolbar and attach the macro to the custom button

oldchippy

thanks again!

Can i run a macro using a formula? For example, in A2 i would write a formula such that when A1 is equal to 1, the macro is run.

I would suggest you Freexe the top 8 or 9 rows and in that area put
hyperlinks to wherever on the sheet you wish to go.......I always put TOP and
BOTTOM arrows and assign appropriate macros on my databases to facilitate
navigation.

hth
Vaya con Dios,
Chuck, CABGx3



"aposatsk" wrote:

>
> I have a sheet which is quite long. I need to create links, or a
> drop-down menu of some sort, which can select different points in the
> same sheet. So, if i click "Bookmark 4", it will scroll/direct the page
> to a certain point in the sheet.
>
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=573799
>
>

You can run a macro via a udf.
Info on creating UDFs here:
http://www.vertex42.com/ExcelArticle...functions.html

Essentially, record a macro, make note of its name, and assign a UDF to it,
say runmacro. So, =runmacro() would, well, run that macro.

--
Brevity is the soul of wit.


"aposatsk" wrote:

>
> thanks again!
>
> Can i run a macro using a formula? For example, in A2 i would write a
> formula such that when A1 is equal to 1, the macro is run.
>
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=573799
>
>