Wierd discovery about Command Buttons

[raymond30031]

Hello,

I have a activeX command button name commandbutton1
When I click on it,
1. it unprotect the sheet
2. shows preview of the chart
3. protect the sheet

Here is the code

Sheet5.Unprotect
Sheet5.ChartObjects("Chart 8").Chart.PrintPreview
Sheet5.Protect

The codes work fine, no error occurs, but the odd part is after I exit the preview screen, every command button on that sheet shifts (moves) to a different place. Either they move up, right , left, or down. The point is that it shouldnt move from where I have placed it. Or should it?

Does anyone has any clue?

Thank you

 

[Ruddles]

Re: Weird discovery about Command Buttons

I experienced a similar thing using ActiveX comboboxes when I rolled out a workbook to a number of users a while ago. They were all using Excel 2007 under WinXP but a mixture of different computers, graphics cards, monitors, etc. Sometimes the comboboxes would slowly edge their way in one direction or another each time the workbook was loaded, sometimes they would get smaller and eventually vanish into a dot.

I ended up having to resize and reposition them every time the workbook was loaded.

 

[RoryA]

Re: Weird discovery about Command Buttons

I would generally recommend you avoid ActiveX controls on worksheets if at all possible and use Forms ones instead.

 

[raymond30031]

Yea, I am experiencing the problem and i am wondering if there is a fix for it?
I am thinking of fixing the button to a position but i do not know how to code that
Any clue?

 

[Von Pookie]

Change the format of the controls to "move and size with cells."

http://support.microsoft.com/kb/838910

 

[raymond30031]

hi, Where is the form control? I opened the properties

 

[RoryA]

Either on the Developer tab (XL2007+) or the Forms toolbar (XL2003-).

 

[raymond30031]

ignore my previous reply, i found it and tried it, but it still doesnt work

 

[GTO]

...