problem with showing on/off tabs with shapes

thanks for the responce
i am tring to run it but it still doesn't want to work
I attached the pic I get . the error I get is : Compile ERROR: variable not defined


thank you so much for the help

Hi again,

Sorry, my BAD!!!

I attached the wrong (non-macro-enabled!) version of the workbook.

See if the attached version works better.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

so first of all thank you so much for your help, It works just great.
and i just wanted to say that for many years i was using excel only for simple info and data collecting program with out trying do more with it , and it is just amazing .

thanks again

Hi again,

Many thanks for your feedback.

and it is just amazing .

It certainly is! I have been working with Excel for 30+ years, and I am still discovering new ways to use it

You're welcome - glad I was able to help.

Best regards,

Greg M

Hello ,
so i started adding links to each shape, and a new problem came up .
it is impossible to add links to each shape ? i mean I am changing the tabs moving between them but
I cant add new link as the one from the first tab is already there?

is it even possible?

Hi again,

so i started adding links to each shape, and a new problem came up

Are you talking about hyperlinks? That may not be the best approach to use.

Do you want each of the various "text shapes" to bring you to an appropriate worksheet? If so, please post a list of the worksheet names and their associated "texts" (cartilage, humerus shaft fractures etc.) and I'll see what I can do - if you want to post only a list of some of the worksheets and "texts" I'll try to set up the workbook so that you can add the remaining information yourself.

Regards,

Greg M

Hi again,

Take a look at the attached workbook and see if it does what you need.

The original "HighlightButton" and "ResetButtons" routines have not been changed.

The remainder of the code has been rewritten as follows:

Please Login or Register  to view this content.

A new table (M1:V14) has been added to the "Texts" worksheet. This table contains the texts of the various webpage addresses that you want to associate with the "menu buttons". I've included the addresses you sent me, so you just need to add the remaining addresses in the appropriate cells of the new table.


Hope this helps - as before, please let me know how you get on.

Regards,

Greg M