Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

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.
--
Thank you, Brenda

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

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
--
Thank you, Brenda


"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda


"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

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?
--
Thank you, Brenda


"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

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.
--
Thank you, Brenda


"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -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???



Brenda wrote:

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?
--
Thank you, Brenda

"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -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?

Brenda wrote:

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?
--
Thank you, Brenda

"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

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.
--
Thank you, Brenda


"Brenda" wrote:

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.
--
Thank you, Brenda

Excel -- Navigation Toolbar for Workbook Sheets -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.

Brenda wrote:

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.
--
Thank you, Brenda

"Brenda" wrote:

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.
--
Thank you, Brenda

--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

dropdown on the Addins tab.

Home tab


--

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


"Dave Peterson" wrote in message ...
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?

Brenda wrote:

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?
--
Thank you, Brenda

"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -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 wrote:

dropdown on the Addins tab.

Home tab

--

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

"Dave Peterson" wrote in message ...
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?

Brenda wrote:

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?
--
Thank you, Brenda

"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

--

Dave Peterson

Excel -- Navigation Toolbar for Workbook Sheets -Dave Peterson
 

Correct, you can use both versions in Excel 2007



--

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


"Dave Peterson" wrote in message ...
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 wrote:

dropdown on the Addins tab.

Home tab

--

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

"Dave Peterson" wrote in message ...
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?

Brenda wrote:

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?
--
Thank you, Brenda

"Dave Peterson" wrote:

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.

Brenda wrote:

I am not getting an error message now but i don't see the toolbar still
--
Thank you, Brenda

"Dave Peterson" wrote:

That code has worked for me.

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

Brenda wrote:

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.
--
Thank you, Brenda

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

--

Dave Peterson