sheet navigation

In my notebook I have several sheets with various information. I would like 
to be able to click on a cell within a sheet that identifies another sheet 
and go to it.

Tahnk you. Bob

Roy,
Not sure what this means or how to get to this point

"When you click the Browse Button to the R of the lowest Edit Box, the 
Dialog
becomes a Title Bar at the top of the window. Navigate to your target cell,
click the Maximize button in the Dialog Title Bar"
    ......   what browse button...what edit box?
"
"lemoto" <ctech@corel.ca> wrote in message 
news:VA.00004a21.00871be4@corel.ca...
>
> Bob:
>> In my notebook I have several sheets with various information. I would

>> like
>> to be able to click on a cell within a sheet that identifies another 
>> sheet
>> and go to it.
>>
> Tools|Hyperlink...
>
> The path is clear from there.
>
> When you click the Browse Button to the R of the lowest Edit Box, the 
> Dialog
> becomes a Title Bar at the top of the window. Navigate to your target 
> cell,
> click the Maximize button in the Dialog Title Bar. This method is common 
> to
> many activities in QP.
>
> I usually use Insert|Form Control|Push Button (with a macro) which can be
> moved. But Hyperlink works, and the link Cell can be Copy/Pasted.
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
> 

Bob:
> In my notebook I have several sheets with various information. I would like

> to be able to click on a cell within a sheet that identifies another sheet

> and go to it.
>
Tools|Hyperlink...

The path is clear from there.

When you click the Browse Button to the R of the lowest Edit Box, the Dialog 
becomes a Title Bar at the top of the window. Navigate to your target cell, 
click the Maximize button in the Dialog Title Bar. This method is common to 
many activities in QP.

I usually use Insert|Form Control|Push Button (with a macro) which can be 
moved. But Hyperlink works, and the link Cell can be Copy/Pasted.
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Bob:
> "When you click the Browse Button to the R of the lowest Edit Box, the

> Dialog
> becomes a Title Bar at the top of the window. Navigate to your target
cell,
> click the Maximize button in the Dialog Title Bar"
>     ......   what browse button...what edit box?

Put the cursor in a handy Cell.

Do: Tools|Hyperlink...

If you will follow that path, you will see the relevant items.
You would not expect to see them before you have progressed to the points at 
which they appear.

An Edit Box is an item in a Dialog in which it is intended that text will 
appear. In this case the text will eventually be a Sheet:ColRow Address.

(What I called a Browse Button, hoping for clarity in this context, is in QP 
known as a Range Picker, an equally comprehensible label.)
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Got it now Roy !!    Thank you (once again)


"lemoto" <ctech@corel.ca> wrote in message 
news:VA.00004a27.01122a28@corel.ca...
>
> Bob:
>> "When you click the Browse Button to the R of the lowest Edit Box,
the
>> Dialog
>> becomes a Title Bar at the top of the window. Navigate to your target 
>> cell,
>> click the Maximize button in the Dialog Title Bar"
>>     ......   what browse button...what edit box?
>
> Put the cursor in a handy Cell.
>
> Do: Tools|Hyperlink...
>
> If you will follow that path, you will see the relevant items.
> You would not expect to see them before you have progressed to the points 
> at
> which they appear.
>
> An Edit Box is an item in a Dialog in which it is intended that text will
> appear. In this case the text will eventually be a Sheet:ColRow Address.
>
> (What I called a Browse Button, hoping for clarity in this context, is in 
> QP
> known as a Range Picker, an equally comprehensible label.)
> -- 
> Good wishes!
> Roy Lewis
> C_Tech volunteer
> (UK)
>
>