How do i make sheet tabs look veritical - again

M

Martin ©¿©¬

Hi Gord
I just can't get the Navigation Toolbar as per Dave's code on Debra
Dalgleish's site to work

Using 2007 instructions
Would there be something you can think of that I'm not doing correctly

I'm missing the Sheet Navigator commands
1. The Sheet Navigator commands should appear at the far right of
the Home tab on the Ribbon..
2. Click the Select a Sheet command, to view a list of sheets in
the active workbook.
3. From the dropdown list, select a sheet, and that sheet will be
activated.

I also didn't use Ron de Bruin's Modify the XML to Add the Buttons
code as I didn't know what I was doing
 
G

Gord Dibben

Have you tried downloading the sample workbook to see if opening that gives
you what you want?

I don't use 2007 so can't test the instructions for that.

Works fine for me in 2003.

I prefer Bob Phillips' browsesheets routine in any case.

No extra toolbar floating around, just a button on an existing toolbar or a
shortcut key combo.


Gord
 
M

Martin ©¿©¬

Have you tried downloading the sample workbook to see if opening that gives
you what you want?

Tried that, but it wouldn't open
I don't use 2007 so can't test the instructions for that.

Works fine for me in 2003.

I prefer Bob Phillips' browsesheets routine in any case.

Where do I find this & how do I use it?
 
G

Gord Dibben

Did you un-zip the downloaded file before trying to open it?

I posted the link to Bob's macro in my first reply to you.

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

http://tinyurl.com/yoa3dw

See the code and comments under my name in that thread.

To use it, copy and paste it into a general module in your workbook or
Personal.xls.

Assign the macro to a button or shortcut key.


Gord
 
M

Martin ©¿©¬

Gord, I feeling my way here as this is all new to me
I'm not making much headway or really know what I'm doing and I'm
wondering if it's worth it.
The idea sounded good, but I'm not gonna bother any more

Thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top