Bring Shape Forward VBA

julhs

Active Member
Joined
Dec 3, 2018
Messages
407
Office Version
  1. 2010
Platform
  1. Windows
Currently I have 2 Shapes centred over each other that I Hide or Un-Hiding as required; but it also needs the action to be reversed (eg Shape1 Hide, Shape2 Unhide, then elsewhere need to do, Shape1 Unhide and Shape2 Hide)

But wondered if bringing one of the shapes Forward as required was a better option, but it would still require elsewhere that this process was reversed.
I fully admit there is virtually no difference in the amount of coding required for either of them but wondered if one option was better than the other?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Perhaps (at a stretch) I'd say having one hidden and one not makes your intent slightly clearer - but if this is the sum of your problems, you're probably in good shape either way :)
 
Upvote 0
Thanks for your comment.
From what you have said and the time I have spent on the Hide/Unhide already, going to leave things as they are.
Many thanks for your help.
Julhs
 
Upvote 0

Forum statistics

Threads
1,215,299
Messages
6,124,132
Members
449,143
Latest member
LightArisen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top