Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL QUERY

Status
Not open for further replies.
arun17

arun17

Mechanical
Joined
Apr 16, 2002
Messages
44
Location
IN
Deat Friends,
I want to write an application using macros in Excel. But I want to control the no of rows and columns when the worksheet is opened. How it can be achieved using macros "Knowledge is power"
 
Sort by date Sort by votes
Try this, set the scroll area when the sheet is opened. It restricts the effective size of the sheet and the operator can only use the fields you set , i.e. "a1:f10".

Add this to the "ThisWorkbook" Open Event

Worksheets(1).ScrollArea = "a1:f10"

Regards,

Dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Coalhouse
  • Locked
  • Question Question
vba excel register udf not working
Replies
3
Views
14K
Coalhouse
Coalhouse
QuijoteMx
  • Locked
  • Question Question
Drawing shapes (lines, boxes, triangles) using vba in an excel graph
Replies
2
Views
1K
SkipVought
SkipVought
EngineerMickeyMouse
  • Locked
  • Question Question
Java - IDE NetBeans - Upgrading excel-like spreadhseet to the windows-like desktop application
Replies
4
Views
419
utkuselamoglu
utkuselamoglu
oscyes
  • Locked
  • Question Question
smart searching with combobox excel vb
Replies
1
Views
226
IDS
IDS
glynnmack
  • Locked
  • Question Question
Access 2007- Query Repeating Records
Replies
2
Views
166
glynnmack
glynnmack

Part and Inventory Search

Sponsor

Back
Top