EXCEL QUERY

[arun17]

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"

 

[dwilson]

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