asked on

Need Help With Disappearing Objects

Greetings experts,

I have a very weird problem...
I have a code embedded in "This Worksheet" and what it does is that it will reset Option Button 1 and 2 and hide some cells whenever the the workbook is re-opened. I also have a button that will show and hide another range of certain cells. If I press any option button, hide the cells and save, when I reopen, all the objects in the hidden range are deleted.

Attached here is an excel file for your reference: Book1.xlsm

Any help is much appreciated! :)

ASKER CERTIFIED SOLUTION

Fabrice Lambert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Noah

ASKER

Oh I see! Is there a way to edit the codes such that all the objects will appear when I reopen the worksheet and show/hide the cells?

SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Fabrice Lambert

If your graphic interface must remain visible, may I suggest to make a form instead ?

Noah

ASKER

Hi everyone, thank you for your replies!

After investigating, I tried to show all objects by using the selection pane. However, like what @Fabrice Lambert said, the objects are behind the cells... How do I select all objects behind the cells and place them in front? :)

SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Noah

ASKER

The problem is I can't even see those lines.. Is there another way?

Subodh Tiwari (Neeraj)

Manually unhide the hidden rows and those lines will be appeared.

SOLUTION