Bookmarks on Sheet

A

aposatsk

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

oldchippy

aposatsk said:
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.
Click to expand...

Hi aposatsk,

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

oldchippy :)
 
A

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?
 
C

CLR

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
 
O

oldchippy

aposatsk said:
Okay. That is a step closer*. But *can i make the "Views" in Custo
Views show up costantly on some toolbar or in a cell?
Click to expand...
Record a macro in this workbook to select your named view, then creat
a new Toolbar and attach the macro to the custom button

oldchippy :
 
A

aposatsk

thanks again!

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