Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help
--
Martin
©¿©¬
.................................................. .................................................. ............................
You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 16:11:01 +0000, Martin ©¿©¬ @nohere.net wrote:

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

Have you download my example 2007 add-in from Debra's site ?
http://www.contextures.on.ca/xlToolbar01b.html

See
Download the zipped sample file.



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Martin ©¿©¬ @nohere.net" wrote in message ...
Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help
--
Martin
©¿©¬
.................................................. .................................................. ...........................
You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 16:11:01 +0000, Martin ©¿©¬ @nohere.net wrote:

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

If you used the old (pre-xl2007) version, look in the Addins group on the
Ribbon.

If you used the xl2007, then see Ron's response.

Martin, ©¿©¬, @nohere.net wrote:

Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help
--
Martin
©¿©¬
.................................................. .................................................. ...........................
You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 16:11:01 +0000, Martin ©¿©¬ @nohere.net wrote:

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

--

Dave Peterson

I don't work with 2007 but with Bob's BrowseSheets code installed in a
general module, you should be able to assign any button to it, or even a
shortcut key combo.

I know nothing about the 2007 Ribbon so can't tell you how to get a new
Toolbar to show up.


Gord

On Mon, 12 Jan 2009 16:20:29 +0000, Martin ©¿©¬ @nohere.net wrote:

Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help

On Mon, 12 Jan 2009 17:32:33 +0100, "Ron de Bruin"
wrote:

Have you download my example 2007 add-in from Debra's site ?
http://www.contextures.on.ca/xlToolbar01b.html

See
Download the zipped sample file.

Hi Ron
Downloaded the zipped sample file (which I couldn't figure out how to
use before) got my workbook open, extracted the zip file and low &
behold the the Sheet Navigator commands did appear at the far right of
the Home tab on the Ribbon < hip, hip

However.., when I save my workbook & open it again the Sheet Navigator
commands aren't there!
What am I doing wrong?
--
Martin
©¿©¬

On Mon, 12 Jan 2009 10:49:06 -0600, Dave Peterson
wrote:

If you used the old (pre-xl2007) version, look in the Addins group on the
Ribbon.

Hi Dave
Nothing in the Addins !
--
Martin
©¿©¬

If you used the xl2007, then see Ron's response.

Martin, ©¿©¬, @nohere.net wrote:

Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help
--
Martin
©¿©¬
.................................................. .................................................. ...........................
You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 16:11:01 +0000, Martin ©¿©¬ @nohere.net wrote:

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

You must install the add-in so it always load when you open Excel

Click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
In the Manage drop-down, click Excel Add-ins, and click Go.

Use Browse to go to the xlam file
Verify NavAdd-in is checked in this list and then click OK.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Martin ©¿©¬ @nohere.net" wrote in message ...
On Mon, 12 Jan 2009 17:32:33 +0100, "Ron de Bruin"
wrote:

Have you download my example 2007 add-in from Debra's site ?
http://www.contextures.on.ca/xlToolbar01b.html

See
Download the zipped sample file.

Hi Ron
Downloaded the zipped sample file (which I couldn't figure out how to
use before) got my workbook open, extracted the zip file and low &
behold the the Sheet Navigator commands did appear at the far right of
the Home tab on the Ribbon < hip, hip

However.., when I save my workbook & open it again the Sheet Navigator
commands aren't there!
What am I doing wrong?
--
Martin
©¿©¬

BTW: you can find this information also on Debra's site

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
You must install the add-in so it always load when you open Excel

Click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
In the Manage drop-down, click Excel Add-ins, and click Go.

Use Browse to go to the xlam file
Verify NavAdd-in is checked in this list and then click OK.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Martin ©¿©¬ @nohere.net" wrote in message ...
On Mon, 12 Jan 2009 17:32:33 +0100, "Ron de Bruin"
wrote:

Have you download my example 2007 add-in from Debra's site ?
http://www.contextures.on.ca/xlToolbar01b.html

See
Download the zipped sample file.

Hi Ron
Downloaded the zipped sample file (which I couldn't figure out how to
use before) got my workbook open, extracted the zip file and low &
behold the the Sheet Navigator commands did appear at the far right of
the Home tab on the Ribbon < hip, hip

However.., when I save my workbook & open it again the Sheet Navigator
commands aren't there!
What am I doing wrong?
--
Martin
©¿©¬

Then I'm guessing you didn't use the old version or you didn't allow macros to
run.

Or you did something else than what was described on Debra's site.

Martin, ©¿©¬, @nohere.net wrote:

On Mon, 12 Jan 2009 10:49:06 -0600, Dave Peterson
wrote:

If you used the old (pre-xl2007) version, look in the Addins group on the
Ribbon.

Hi Dave
Nothing in the Addins !
--
Martin
©¿©¬

If you used the xl2007, then see Ron's response.

Martin, ©¿©¬, @nohere.net wrote:

Hi Gord
No Matter what I do with Dave's code or Bob Phillips browseSheets
macro, I can't get this to work. It goes through all the setup
routine fine, but The Sheet Navigator commands doesn't appear at the
far right of the Home tab on the Ribbon
Can u offer any further help
--
Martin
©¿©¬
.................................................. .................................................. ...........................
You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Gord Dibben MS Excel MVP

On Sun, 28 Dec 2008 16:11:01 +0000, Martin ©¿©¬ @nohere.net wrote:

This works fine, however, as I have 20 odd sheets in my workbook,
I need to return to the original sheet or go to another sheet from the
sheet I have just selected & so on back & forth
Probable something like a floating toolbar that moves from page to
page - how do I do that please?

--

Dave Peterson

On Mon, 12 Jan 2009 18:54:59 +0100, "Ron de Bruin"
wrote:

You must install the add-in so it always load when you open Excel

Click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
In the Manage drop-down, click Excel Add-ins, and click Go.

Use Browse to go to the xlam file
Verify NavAdd-in is checked in this list and then click OK.

Thanks Ron
Must be me or something I didn't do correctly
Still not working !
--
Martin
©¿©¬