Navigation Toolbar help- Gord Dibben

[Martin ©¿©¬]

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

 

[Ron de Bruin]

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.

 

[Dave Peterson]

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.

 

[Gord Dibben]

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

 

[Martin ©¿©¬]

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 ©¿©¬]

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

Hi Dave
Nothing in the Addins !

 

[Ron de Bruin]

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.

 

[Ron de Bruin]

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

--

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

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.

 

[Dave Peterson]

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 ©¿©¬]

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 !