Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson

[Brenda]

I have tried to install the Navigation toolbar that Dave Peterson developed.
I followed the instructions step by step everything was correct until i got
to the part where the toolbar should be floating over the worksheet. I am
getting an error when i open excel "Run-time error '5' and it also says
Invalid procedure call or argument. Any idea what is happening? I am going to
post this a couple other areas so that i can get this figured out. I think
it will help me in other areas in learning how to do macros and find my
sheets.

 

[Dave Peterson]

That code has worked for me.

Can you post your version of the code and indicate the line that breaks.

 

[Brenda]

This is where i get the error message

Sub Auto_Close()
On Error Resume Next
Application.CommandBars("MyNavigator").Delete
On Error GoTo 0
End Sub

 

[Brenda]

I am not getting an error message now but i don't see the toolbar still

 

[Dave Peterson]

If you close and reopen the workbook (so the toolbar is recreated), do you see
it?

If you click on Tools|Customize, do you see the MyNavigator toolbar in the list
of toolbars?

Is it checked?

If it's not checked, check it and then look for it again.

I am not getting an error message now but i don't see the toolbar still

 

[Brenda]

I do not see the toolbar in the list. I am now getting the error again when i
open up excel. Can i delete everything and start fresh?

 

[Brenda]

If i close and reopen the workbook and go to tools/customize i do see the
name i gave the toolbar and yes it is checked. But that is as far as i get
error pops up.

 

[Dave Peterson]

Did you build the workbook yourself or did you just download the sample workbook
from Debra's site?

If you built it yourself, maybe downloading the sample workbook would work
better--and you may be able to find any problems???

I do not see the toolbar in the list. I am now getting the error again when i
open up excel. Can i delete everything and start fresh?

 

[Dave Peterson]

ps. If you're using xl2007, you won't see a floating toolbar. You'll see the
dropdown on the Addins tab.

Are you using xl2007?

I do not see the toolbar in the list. I am now getting the error again when i
open up excel. Can i delete everything and start fresh?

 

[Brenda]

I will be honest this has created a mess of issues on my computer. I get
errors when i start up excel i can't delete old add-ins therefore i can't
even insall the sample workbook because i have a addin with the same name. I
wondering what to do now with my computer. This is the message i get when i
open excel Run-time error '5':
Invalid procedure call or argument.

David any help would be greatly appreciated.

 

[Dave Peterson]

I still have no idea what's causing the run time error "5".

But you can close excel and move or delete that addin (or workbook) that does
the navigation toolbar.

Then you should be able to start excel and uncheck that addin.

I don't know anything about the second file with the same name.

 

[Ron de Bruin]

dropdown on the Addins tab.

Home tab

 

[Dave Peterson]

It'll depend on which version of the addin...

If I download the file (*.xla) from http://contextures.com/xlToolbar01.html
(from Debra Dalgleish's site), it'll be shown in the Addins tab.

If I use the one (*.xlam) from http://contextures.com/xlToolbar01b.html (that
you modified for xl2007), it'll be shown on the Home tab.

But thanks for the opportunity to clarify!

 

[Ron de Bruin]

Correct, you can use both versions in Excel 2007