forward and back buttons in EXCEL
 

Hi,
Is it possible to have forward and back buttons (just like IE) feature in
EXCEL?
here is the scenario:
I open workbook2 from my workbook1 using VBA code thru a command button.
I want to be able to come back to workbook1 using a <BACK button from
workbook2. Is this possible? Any ideas?

forward and back buttons in EXCEL
 

Ctrl-F6 tabs through open workbooks.

Ctrl-PageUp and Ctrl-PageDown tab through worksheets.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kanan" wrote in message
...
Hi,
Is it possible to have forward and back buttons (just like IE) feature in
EXCEL?
here is the scenario:
I open workbook2 from my workbook1 using VBA code thru a command button.
I want to be able to come back to workbook1 using a <BACK button from
workbook2. Is this possible? Any ideas?

forward and back buttons in EXCEL
 

or CTRL+TAB for forward through books
and CTRL+SHIFT+TAB for backward through books

Regards,
Sébastien

"Bob Phillips" wrote:

Ctrl-F6 tabs through open workbooks.

Ctrl-PageUp and Ctrl-PageDown tab through worksheets.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kanan" wrote in message
...
Hi,
Is it possible to have forward and back buttons (just like IE) feature in
EXCEL?
here is the scenario:
I open workbook2 from my workbook1 using VBA code thru a command button.
I want to be able to come back to workbook1 using a <BACK button from
workbook2. Is this possible? Any ideas?

forward and back buttons in EXCEL
 

thanks for the info. This is just FYI. I do see the back and forward buttons
in my Workbooks when I open WB2 from WB1 using the followhyperlink method
instead
of the workbooks.open command.

thanks
Kanan

"sebastienm" wrote:

or CTRL+TAB for forward through books
and CTRL+SHIFT+TAB for backward through books

Regards,
Sébastien

"Bob Phillips" wrote:

Ctrl-F6 tabs through open workbooks.

Ctrl-PageUp and Ctrl-PageDown tab through worksheets.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kanan" wrote in message
...
Hi,
Is it possible to have forward and back buttons (just like IE) feature in
EXCEL?
here is the scenario:
I open workbook2 from my workbook1 using VBA code thru a command button.
I want to be able to come back to workbook1 using a <BACK button from
workbook2. Is this possible? Any ideas?