+ Reply to Thread
Results 1 to 6 of 6

Stop Scrolling in Macro

  1. #1
    Registered User
    Join Date
    11-28-2020
    Location
    Rochester NY
    MS-Off Ver
    2019
    Posts
    4

    Stop Scrolling in Macro

    Macro:
    Sub ViewConditionalFormatting()
    '
    ' ViewConditionalFormatting Macro
    '
    Range("G2").Select
    If ActiveCell = True Then
    ActiveCell = False
    Else
    ActiveCell = True
    End If
    '
    End Sub

    I have a conditional formatting set determined by the value of cell G2 being TRUE/FALSE.
    I added a button to the quick toolbar using that macro, which works wonderfully. But, when I run it, the sheet scrolls up to cell G2. How can I eliminate that so it stays where I was? Thanks
    Last edited by SESchmidt; 11-29-2020 at 04:14 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Stop Scrolling in Macro

    How about
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-28-2020
    Location
    Rochester NY
    MS-Off Ver
    2019
    Posts
    4

    Re: Stop Scrolling in Macro

    how do I incorporate that into the macro? I'm new at this. thanks

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Stop Scrolling in Macro

    It replaces all your code.

  5. #5
    Registered User
    Join Date
    11-28-2020
    Location
    Rochester NY
    MS-Off Ver
    2019
    Posts
    4

    Re: Stop Scrolling in Macro

    SOLVED Thanks! Exactly what I needed.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Stop Scrolling in Macro

    You're welcome & thanks for the feedback.

+ 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. Stop Scrolling
    By victorjesse in forum Excel - New Users/Basics
    Replies: 16
    Last Post: 01-03-2012, 08:01 PM
  2. Stop Scrolling?
    By aldawson38 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 12-19-2011, 03:23 AM
  3. How to stop scrolling
    By bengaluru in forum Excel General
    Replies: 2
    Last Post: 08-06-2009, 12:40 PM
  4. Stop scrolling
    By ledzepe in forum Excel General
    Replies: 5
    Last Post: 04-02-2007, 01:35 PM
  5. How do I stop the scrolling?
    By lady digitalvideo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-07-2006, 11:08 PM
  6. Stop scrolling
    By gottahavit in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 11:35 AM
  7. stop the scrolling in VBA
    By mowali in forum Excel General
    Replies: 0
    Last Post: 04-07-2005, 04:55 PM
  8. [SOLVED] scrolling won't stop
    By orfan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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