Unhide & hide Shapes.

Dear All,

I hope you are all well.

I have a simple task that it might be very simple for the majority of you but I have been struggling to get it right (I am very basic with VBA codes).

On the attached file "Menu" I have a shape (named "Menu") that when clicked, a new group of shapes are shown.

I just need a piece of code that will hide the group of shapes again when the button "Menu" is clicked again.

Any ideas will be highly appreciated.

Best regards,
Filipe

Please Login or Register  to view this content.

Hi yudlugar,

A million thanks for your flash reply and assistance on this matter.

Really appreciated

Best regards,
Filipe.

Sorry yudlugar,

Just a quick question.

Is it possible to have the same effect but instead of a click, is it possible to have the same with a MouseOver event?

Best regards,
Filipe

Ha, that's a little more difficult... (shapes don't have a mouseover event)... Have a read here:
http://www.excelforum.com/excel-prog...utoshapes.html

Thanks again yudlugar,

I saw that thread before, it's much more complicated than I thought.

The mouse over event seems that will only works (on a simple way) in UserForms.

I am creating a worksheet that looks like a website, rather than Excel. My goal was having a row with menus than when hoovered they could see sub-menus and click their option.

This workbook have lot's of worksheets and that would facilitate the navigation.

No worries, they will have to click each menu if they want to see their correspondent Sub-Menus.

Thanks a million again.

I will keep this thread unsolved for a while in case someone have a different idea.

Best regards,
Filipe