Does this help?
.Rows("12:22").Hidden = True
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Christopher Kevin
Sent: Sunday, January 15, 2012 4:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please
Can you experts help me with my problem?
What I want is:
When the previous < button is clicked, I want only records up untill row 7 to
show on the Form Sheet as per the attached Room Reservation Sheet.
And the same should be applied to the go to last record << button. That is I
want row 7 to be the last row and not going back beyond row 7 to row 1.
How can that be done as per the attached file?
The that I currently have is included in file.
Additional Explaination:
When I clcik the << and < buttons, column headers and blank rows above row 7
are also populated on to the Form. How can this be avoided?
I hope I have explained myself clearly.
Thank you all you experts in advance for any help that may be provided.
Chris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
