A few days ago, somebody asked me how to limit the scrolling of a worksheet as soon as he opened his workbook file. He intended to make the first sheet as a Title Page so he should find a way to do it. At first, I thought it was just a simple Excel "setup" workaround at the Tools menu. But after a few minutes of looking around it, I didn't find a way to do the task (or maybe there was one but I didn't find it). So, I ended up making a simple Macro program at the workbook's "Open" event. Here's how I did it:
Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "a1:f10"
End Sub
The code limits the scrolling of the worksheet from cell A1 to F10 only.
Try it.
Hey Joel, thanks for the neat code trick. I checked out your SEO blog and found the link to kping.com, very useful! But are you sure some of the tips don't lower your ranking, I mean some of them look like link farms or short term boosts that in the long run can hurt your Google listing.
Thx,
JP
You could be right JP. I've been trying a lot of things to improve my traffic. Some of them worked but gives me lower PR. Luckily, I've regained my PR with my SEO Blog. I still use some of them but in moderation. It's giving me both traffic and stable PR.
Thanks for the visit JP.
Rgds,
Joel