Buttons need to hide/unhide along with columns

If you open up the attached file you'll notice that when you click the hide button that the buttons are sometimes hiding, but not every time and not all of them.

I have this same style macro on a much larger scale (188 different buttons) where the buttons won't hide.

What I need is for the buttons to disappear when the columns they are in disappear.

I tried flipping the column resize (to make the columns disappear) and button visibility. Still not working as soon as I move to a new station. Soooo frustrating for me.

To clarify my problem further. The buttons are working fine, and hiding/unhiding like I'd like. The columns are resizing correctly. My issue is that when the buttons reappear when I open the document on a different workstation the buttons all open up on top of each other when I make them visible again instead of in the cells on the columns. Please see the attached image. Apologies for the redaction. Eventually all those "button 1s" will say something more descriptive.

Could it be because the buttons are becoming visible after the cells are resized in the VBA?

I'm still having issues with the buttons not moving into their initial cells when opening the document on another workstation.

Also, the file you attached isn't opening for me. It's saying it is corrupted, and the buttons aren't appearing.

Thank you for all of your help!

The test file has corrupted on my PC too .... I'll have another go at it when I get home later.

Is the other workstation using the same excel version?

Yes sir. Same version. However, when this finally goes live it will also be on stations that have Office '07.

Thank you!


P.s. Birmingham supporter? I arbitrarily assigned Leeds as my team back in the O'Leary days. Probably a bad time to pick them up. Been rough since ~04.

RowlandJP

I had the same issue and was ready to give up... in the end I did!

I hope you have momre luck than me, however the following link seemed to have some relevance to the ActiveX controls, not sure if its the same with the form controls or not
http://support.microsoft.com/kb/2503335

Good luck,

Mowgli

Oh wow, so would I have to apply this fix to every computer that would need this macro?

Thanks for your response. Made me laugh, and it's good to know it's a Microsoft error not a I'm doing something dumb error.

Sorry, could not find this thread at home last night, glad you got an answer. I would not have known that.

P.S. Yes life long Birmingham City fan so don't ask me anything about football

RowlandJP,

Yep it would mean patching every workstation, which our illustrious IT department will not do, therefore I could not check if it worked even.

I did hear from someone that they thought it would only fix anything which was created AFTER the hotfix was applied (was someone from my IT department though and they were maybe just trying to get out of doing something about it), and there was no way I was going to start from scratch again so I redesigned my sheet to use data validation instead of drop down boxes etc.

Could you maybe redesign the sheet to remove the buttons and maybe have them on separate forms which the first buttons make visible or hide? Just a thought that should hopefully then work on any workstation or version of Excel.

Mowgli

Fix worked. IT applied change. I did not have to rebuild the entire document. Seems to be working fine. Thank you!