Results 1 to 3 of 3

Thread: Scroll Lock and Unlock using VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-06-2011, 11:16 AM #1
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14

    Scroll Lock and Unlock using VBA

    Hi,

    I need VBA code to lock and unlock the scroll area.

    Thanx in Advance.
    Reply With Quote Reply With Quote
  2. 10-06-2011, 11:21 AM #2
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Code:
    Worksheet("NameOFSheet").ScrollArea = ""'To Unlock
Worksheet("NameOFSheet").ScrollArea = $A1:$M$20"'To Lock


    https://www.youtube.com/watch?v=ySENWFIkL7c&lc=UgyqIYcMnsUQxO5CVyx4AaABAg
    Last edited by DocAElstein; 07-09-2023 at 07:30 PM.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  3. 11-08-2011, 08:59 AM #3
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Thanx for this useful function.
    Working!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Lock Cells After Data Entered
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 06-28-2013, 10:52 PM
  2. Lock a colum after one pane had been freezed
    By pejoi78 in forum Excel Help
    Replies: 1
    Last Post: 08-08-2012, 09:23 PM
  3. How to Lock or Unlock row basis previous cell input?
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 07-25-2012, 02:40 PM
  4. Adding Scroll bar to image box in vba
    By princ_wns in forum Excel Help
    Replies: 1
    Last Post: 12-13-2011, 09:47 PM
  5. Lock cells on the basis of date VBA
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 22
    Last Post: 09-27-2011, 03:56 PM

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
  •  

Forum Rules