Scroll Lock and Unlock using VBA [Archive] - Excel, Access, PowerPoint and Word VBA Macro Automation Help

View Full Version : Scroll Lock and Unlock using VBA

LalitPandey87

10-06-2011, 11:16 AM

Hi,

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

Thanx in Advance.:cool:

Excel Fox

10-06-2011, 11:21 AM

Worksheet("NameOFSheet").ScrollArea = ""'To Unlock
Worksheet("NameOFSheet").ScrollArea = $A1:$M$20"'To Lock

https://www.youtube.com/watch?v=ySENWFIkL7c&lc=UgyqIYcMnsUQxO5CVyx4AaABAg (https://www.youtube.com/watch?v=ySENWFIkL7c&lc=UgyqIYcMnsUQxO5CVyx4AaABAg)

LalitPandey87

11-08-2011, 08:59 AM

Thanx for this useful function.
Working!
:cool: