Layer arrange problem

[Noz2k]

In a workbook that I created for multiple users there is a large diagram. The idea is that the users move arrows (provided beneath) to point to specific locations on the diagram.

This works for almost everybody, however on 1 users computer the arrows always come up behind the diagram, and therefore cannot be seen. Have tried right clicking the large diagram and sending to back, or right clicking the arrows and sending to front, but it makes no difference.

Does anybody have any idea what might be causing this? Are there any settings which he could have enabled/disabled which would cause this to happen?

 

[baitmaster]

I dont know what would cause this, but you could create a userform with the images on it instead. This might look quite slick, and be a good intro to forms if needed

are you using normal images or ActiveX controls?

 

[Noz2k]

There are already userforms which populate this form. Basically there is an ID combobox (activex) at the top, which when changed populates most of the form with the data already recorded for that specific ID.

There are other buttons, which save, add pages, print, etc when needed. But for the bulk it just populates cells on a worksheet set out like a form.

When the combobox changes it already deletes the arrows on the diagram, creates new ones (with the same name), and places them neatly at the bottom right of the diagram, for the next user to use.

It works perfectly fine from what I am aware for 99% of the users. It's just 1 user (who happens to be the person all the completed forms get sent to), that on his laptop (and his laptop only) all the shapes show behind the diagram.

It must be to do with his settings, but for the life of me I have no idea what would cause it. I know he has to manually enable macros whenever he opens the workbook, but unsure if this would make any difference (especially after being enabled).

 

[baitmaster]

I cant see why there would be a problem here, other than the system assuming the person receiving the forms is the boss, and deliberately trying to p*ss you off, I get this quite a bit

I assume that we are talking about the same types of userform, i.e. the pop up ones that are specifically built in VBA, not just buttons laid out on a sheet somewhere

You could try bringing all the buttons to the front when you create them, using something like

ActiveSheet.Shapes("CommandButton1").ShapeRange.ZOrder msoBringToFront

Other than that I'm out of ideas, sorry

 

[Noz2k]

I know, I think they call that Murphy's (or Sod's) Law. It already has a line in the code which brings them to the front. It works on every other computer seemingly. Which to be suggests the error isn't with the code.

You can't even manually change the order, so it's just strange.