Monday, June 18, 2012 10:08 PM
I have 5 worksheets in my shared workbook.
On each worksheet is an ActiveX scrollbar which, when clicked, hides some columns and shows others (using VBA code).
The scrollbar has the "Don't move or size with cells" property set, but I am still seeing the scrollbar reducing in size and sometimes even moving up or down. This behaviour seems random and is very difficult to replicate, but I am getting the sense that it is somehow caused by changing zoom levels.
Sometimes I see the scrollbar change to a tiny size, but moments later it reverts back to the correct size.
I can't programmatically reset the size and location of the scrollbars because the workbook is shared. I can't use a Forms scrollbar because I need to set the .Max property of the scrollbars, which is unavailable in shared workbooks.
Has anybody else had experience with ActiveX controls on a worksheet resizing and moving location? Are there any ways around this buggy behaviour?
Any help would be greatly appreciated.
- Edited by maddeveloper Monday, June 18, 2012 10:09 PM
Tuesday, June 19, 2012 5:34 AM
You are combining two problems I'm afraid:
1. Shared workbooks. This is a very unreliable feature of Excel I advise you to stop using altogether.
2. Zoom level other than 100% combined with activeX controls. ActiveX controls are not very stable in Excel 2007/2010 unfortunately. Changing zoom levels on sheets with activex controls is reported very often to produce the effect you describe.
Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com
- Marked As Answer by maddeveloper Tuesday, June 19, 2012 9:24 PM