+ Reply to Thread
Results 1 to 6 of 6

Help with code screen updating and locking first sheet

  1. #1
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    195

    Help with code screen updating and locking first sheet

    I am having issues with this code. It does work but the screen flickers when pushing the CLEAR macro. Also for some reason it locks all but the first sheet. Its shoudl alos lock the first sheet with cells C29:H35 and H2 left unlocked.

    Here is the code and the attached sheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,221

    Re: Help with code screen updating and locking first sheet

    Try...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    195

    Re: Help with code screen updating and locking first sheet

    It locks now but the screen still flickers and you can see the cursor moving up and down.

    See attached
    Attached Files Attached Files

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,904

    Re: Help with code screen updating and locking first sheet

    Try this then.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    195

    Re: Help with code screen updating and locking first sheet

    That worked, I have never seen that removed on the top like that (screen updating). Thank you so much!!!

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,904

    Re: Help with code screen updating and locking first sheet

    Glad to help.

+ 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. [SOLVED] Trying to clean up this code and use screen updating
    By g1terra in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2020, 12:33 AM
  2. [SOLVED] Screen updating and enable events code
    By dummy777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2019, 05:37 AM
  3. Help Needed with Screen Updating Code
    By RHONDAK72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2018, 04:20 AM
  4. Excel 2016 screen flashing between two workbooks despite screen updating turned off
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2016, 03:07 PM
  5. Screen Updating = False not working - need help to remove .select from code?
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2014, 08:58 PM
  6. Replies: 4
    Last Post: 01-23-2014, 07:05 AM
  7. Screen locking issue
    By incommlyndon in forum Excel General
    Replies: 0
    Last Post: 11-08-2013, 11:23 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