+ Reply to Thread
Results 1 to 5 of 5

Automatic resizing of form control (Scroll Bar)

  1. #1
    Registered User
    Join Date
    11-24-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    11

    Question Automatic resizing of form control (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.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,874

    Re: Automatic resizing of form control (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

  3. #3
    Registered User
    Join Date
    11-24-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Automatic resizing of form control (Scroll Bar)

    Thanks @NeedForExcel for the reply.

    I already tried that, but it still gets resized automatically especially when I click the macro option to hide/unhide the scroll bar (form control)

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,874

    Re: Automatic resizing of form control (Scroll Bar)

    Does you code specify anything that resizes the Control?

  5. #5
    Registered User
    Join Date
    11-24-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Automatic resizing of form control (Scroll Bar)

    Nope.
    The VBA code line that mentions the scroll bar are
    Please Login or Register  to view this content.
    &
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Form control scroll bar moves too fast.
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2015, 06:19 PM
  2. Scroll Bar (Form Control)
    By cityinbetween in forum Excel General
    Replies: 3
    Last Post: 07-23-2014, 02:29 PM
  3. [SOLVED] Scroll bar isn't moving data (Form Control)
    By bxk006 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2014, 12:54 AM
  4. Scroll bar form control won't stop
    By Bishonen in forum Excel General
    Replies: 1
    Last Post: 07-13-2013, 12:10 PM
  5. How to use a Scroll bar (form control)
    By RA_Lek in forum Excel General
    Replies: 2
    Last Post: 07-07-2013, 11:18 PM
  6. Scroll Bar (Form Control) is lagging when scrolling
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 10:43 AM
  7. Scroll bar (Form Control) - Resetting the scroll bar to particular values
    By Vishb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 04:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1