Displaced control buttons after hide unhide

Hello,

When i hide rows and the contol buttons on those rows, it some times happend that the buttons don't get back to the place where they belong after unhiding the rows. Why does this happen and what can i do about it?

Thanx for replying!

I think you need the Move and size with cells option checked (if I'm reading your question correctly).

Coun't do that because i'm adding rows with these buttons and should remain on right spot when extra rows are added.

setting are now Move but don'r size with cells.

I works propely for most of the time, hiding and unhiding, but sometimes the placement of buttons gets mixed up... It happens somethings after saving and closing the excel when buttons are hidden and when i start it again the hidden buttons get displaced to one spot where the hidden rows were/are.

Am i makking any sense? my colleague has the same problem...

Solved it with some extra coding...


For d = 1 + (bh - 1) * 10 To 10 + (bh - 1) * 10
ActiveSheet.Shapes("CommandButton" & d).Visible = True
ActiveSheet.Shapes("CommandButton" & d).Top = Yplace(d, 1)
ActiveSheet.Shapes("CommandButton" & d).Left = Yplace(d, 2)
Next d

Putting them back to there place if excel is going crazy again

But if anyone knows the back ground of this issue...