1. sparky2205

    Issue scrolling on a spreadsheet

    Hi folks, I have a spreadsheet which I've been using successfully for months. I updated it this morning with some text. To achieve this I had to unprotect the spreadsheet and unfreeze panes. I made my changes, put freeze panes back on, protected it again and then saved it. Now when I try to...
  2. B

    Expand default size of Define Name dialog box

    I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up...
  3. A

    What did I do to the scroll bars in my UserForms?

    I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've...
  4. A

    Help Scrolling an IE modal

    First off, I appreciate all of your time in reviewing and potentially responding to my inquiry. I have a webpage that loads a modal that is longer than the page displays requiring me to scroll down to get the second screenshot. I have not been able to programmatically scroll the modal despite...
  5. N

    Scroll bar - what comes first

    Can anyone tell me what action comes first with a form control scroll bar- the assigned macro or the action of the scrolling bar moving? if the scroll bar moves before the macro is ran, can you delay the action of the scrolling? or is there a way to have a part of the macro run first? Thank...
  6. Z

    cell highlighting while scrolling with cursor

    I am trying to figure out how to scroll through a data set and have the row and column or just the row highlight as I am scrolling. I do not want to have to click to change rows. I have seen this on a few other sites but I cannot figure out how to complete this task. Any suggestions?
  7. xeven_

    Excel 2016 issues?

    I have to ask has anyone else noticed issues with excel 2016 being slow or is it my high quality laptop? I use a desk top at work and when scrolling large strings of data from top to bottom it is fast as it should be yet when at home on my laptop with this 2016 version and scrolling the same...
  8. B

    Alternating Cell Color based off ID Number

    Hi, I want to base alternating colors off the value in one column. For example below when ID changes the color alternates. This will make it much easier to know when a record changes when scrolling through a list with may rows and columns and the ID may not be in view. <tbody> ID Status...
  9. E

    Scrolling Through ListBox Items

    I have a small order management system in Excel. In one of the ListBoxes the user selects the order they want to look at. Now that there are lots of orders, users now have to do a lot of scrolling. If I make the ListBox wider, is there a way to wrap my item list more or less into columns so...
  10. B

    Excess Excel scrolling on an Apple Mac computer

    I have an Apple Mac Computer with Excel installed on it. When I scroll down while in a spreadsheet, I am unable to easily stop the scrolling by using the mouse and/or touch pad. My question is: Is there a fix or a process that I can implement in order to better control the continual scrolling?
  11. N

    Freezing Column / Rows

    I have a work book that I would like to set up a freeze for column A and then in cell C5 freeze the the column and row so when scrolling the dataset I do not want the rows in column A to scoll but stay fixed and have the data in all cells from column B the ability to scroll. There is a small...
  12. E

    Static Macro Shapes When Scrolling

    Hi, Would there be a way to stop shapes moving when scrolling I have 4 rounded rectangles that I use as macro buttons and would like the to sit to the right near the top of the screen when scrolling Not sure if its even possible Many thanks for any help
  13. K

    VBA scrolling to cell A1

    I am trying to return to Cell A1 in a very large spreadsheet however the window will not scroll with the Macro I have created. I do have the Freeze Rows and Columns turned on. The window stays on column BC. Does anyone have any solutions? Thank you
  14. A

    Form View doesn't match Design View - Forced to Scroll When Unnecessary

    Hi all, I've been studying form properties, and can't find what is causing this issue. In Design View, all my buttons can be seen on a single page without the need to scroll. When I open up the Form View, there is a large bar of whitespace where my bottom buttons should be ... I can scroll...
  15. N


    Hi All, My worksheet has close to 200 checkboxes and some hidden rows, and a couple textboxes. I believe that is what is causing this flickering/slowness I am experiencing just simply scrolling up and down the worksheet. Is there anything that can prevent this from happening?
  16. B

    can command button move with scrolling?

    if iam scrolling my sheets i want to move my command button to keep visible while scrolling is it possible?
  17. M

    Viewing Records in Form Issue

    Hello, I created a form in access and was scrolling through the records, but I don't see any records. There are 4 records in the table tied to this form, but while scrolling to the next record it is blank. What am I missing? I see the refID changing and the date reviewed is also changing but...
  18. R

    Scrolling bar in a single cell

    Hi everyone, I may not be wording my search correctly as I have not found the answer to this question. How do I create a scrolling bar for a single cell. I have a workbook with the month (R3) and would like to be able to use the scroll button on the mouse to select the proper month...
  19. E

    simultaneous scrolling among certain sheets

    Hi all, Is there a VBA code to have Excel scroll simultaneously among different sheets (not all sheets, only specific ones)? I would need something like the below but without having ALL sheets move their position... Sub SynchSheets() ' Duplicates the active sheet's cell position in each...
  20. M

    Scrolling Right and Left in Excel 2013 365

    Howdy! In excel 2007 and earlier excel had the ability to scroll right and left by simply 'nudging' the wheel of the mouse right or left [Yes I am aware you can also push the scroll wheel down and move the mouse in any direction, I don't like this method]. I'm currently using my corporate...

Some videos you may like

This Week's Hot Topics