Run Time Error

[tuckjoseph]

Hi,

I'm getting a run time error on this code in Excel 03:

Please Login or Register  to view this content.

Huh?

[davesexcel]

I cannot Replicate the error

[Jack in the UK]

Try this:

Please Login or Register  to view this content.

[tuckjoseph]

Thanks guys.

It takes me to debugger with that code. Maybe I have added it to the workbook incorrectly?

The error alert window says "Run-time error '-2147467259 (80004005)': Method 'Execute' of object '_CommandBarButton' failed" if that means anything to anyone. I stupidly used command buttons, that only function in design mode, to produce a navigating workbook.

Rather than reproduce the whole thing with autoshape buttons, I'd rather just sort this issue. It doesn't seem to affect all users so I thought it may be something to do with specific users settings, but I've come up blank!?

Thanks again.

[Jack in the UK]

Please Login or Register  to view this content.

Should be ok,,, tests here OK

[Andy Pope]

How do you get the buttons to function in design mode?

Can you post small example of your file. It's not clear what your actual problem is.

[tuckjoseph]

Sorry for being so dippy

An example workbook is attached.

Jack in the UK - not sure what I need to do with that code, or are you suggesting the code I'm using works for you?

Thanks.

[Jack in the UK]

How do you get the buttons to function in design mode?

Don’t thing you can use the buttons at run time, you can make them appear thus my code, but really you use / call the buttons code from VBA -- or i have this all wrong again

In design view you cant do a lot

my code runs and does what your asking,,, agreed its not really going to solve your problems however it is what you asked for without exploding

[Andy Pope]

The button only works in design mode because you appear to have a hyperlink assigned to the button.

If you want to use the activex controls then you need to place code in the click event of the control.

Please Login or Register  to view this content.

[tuckjoseph]

Thanks again.

Seems there may not be a solution then. I have over 250 documents, all with 25 hyperlinks assigned to similar command buttons so going into each one to correct hyperlinks is not realistic. I've learnt my lesson and will never use command buttons again (damn you excel 03!), but it looks like I will have to teach users who experience this error (not very confident users mind) how to go into design mode.

I appreciate your help, I guess this will be another one of excels little mysteries!

Joe

[davesexcel]

Thanks again.

Seems there may not be a solution then. I have over 250 documents, all with 25 hyperlinks assigned to similar command buttons so going into each one to correct hyperlinks is not realistic. I've learnt my lesson and will never use command buttons again (damn you excel 03!), but it looks like I will have to teach users who experience this error (not very confident users mind) how to go into design mode.

I appreciate your help, I guess this will be another one of excels little mysteries!

Joe

Try the buttons on the Forms toolbar instead of the Controls Toolbar, they are easier to work with.

Press Ctrl & K to insert a HyperLink, no buttons are required.

[tuckjoseph]

Hi Dave,

Thanks for the heads up, I have found it easiest using AutoShapes (since creating these spreadsheets) as they behave just like a button when a macro or hyperlink is assigned them and they have more flexibility presentationally. Do you know of any differences between them and the button tool on the forms toolbar?

I know I won't make this same mistake again, just wish I knew why I was getting this run time error!

Joe