View Single Post
 
Old 10-05-2020, 03:29 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

It looks like you've created additional Marking 1 shapes in your workbook. The workbook I had only had one Marking 1 shape and your screen capture shows 4 of them now. The code I had created to move that one item is going to need to be adapted to deal with the extra 3 instances.

There can be a point where the coding of alternate layouts for multiple conditions becomes so complicated that it can be good to step back and consider alternatives. One such alternative is different worksheets for each layout option and your code starts by hiding sheets and only showing the preferred worksheet and then changes a little text or that 'active' sheet. I'm not sure you are at that point yet but it is worth considering if you intend to keep moving the goalposts as it opens up the layout options considerably.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote