I had used a form control (scroll bar) in my excel workbook, but it gets resized automatically at times.
What could be done to avoid this? I do have some VBA codes in the workbook, but nothing related to the scroll bar.
I had used a form control (scroll bar) in my excel workbook, but it gets resized automatically at times.
What could be done to avoid this? I do have some VBA codes in the workbook, but nothing related to the scroll bar.
Maybe this will work
Right Click On the Scroll Bar > Format Control > Properties > Don't move Or Size With Cells
Cheers!
Deep Dave
Thanks @NeedForExcel for the reply.
I already tried that, but it still gets resized automaticallyespecially when I click the macro option to hide/unhide the scroll bar (form control)
Does you code specify anything that resizes the Control?
Nope.
The VBA code line that mentions the scroll bar are&![]()
ActiveSheet.Shapes("Scroll Bar 12").Visible = False
![]()
ActiveSheet.Shapes("Scroll Bar 12").Visible = True
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks