How do I unhide a row when ENTER is pressed in a certain cell?

[Saucer Man]

I want to hide all rows after the last row in a worksheet. When the user
finishes entering data in the last row and hits ENTER in the last cell
(column R) in the last row, I want the next row to "unhide" and the
cursor/selection placed on the first cell in this next row. How can I
accomplish this?

Thanks!

 

[GS]

Saucer Man submitted this idea :

I want to hide all rows after the last row in a worksheet. When the user
finishes entering data in the last row and hits ENTER in the last cell
(column R) in the last row, I want the next row to "unhide" and the
cursor/selection placed on the first cell in this next row. How can I
accomplish this?

Thanks!


--- Posted via news://freenews.netfront.net/ - Complaints to
(e-mail address removed) ---

You can do this via VBA. However, if you simply want to emulate a new
input row to 'appear' after entries in the last row are made, there are
ways to accomplish this using Conditional Formatting and sheet
protection to manage navigation.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Don Guillett]

I want to hide all rows after the last row in a worksheet. When the user
finishes entering data in the last row and hits ENTER in the last cell
(column R) in the last row, I want the next row to "unhide" and the
cursor/selection placed on the first cell in this next row. How can I
accomplish this?

Thanks!

I want to hide all rows after the last row in a worksheet. When the user
finishes entering data in the last row and hits ENTER in the last cell
(column R) in the last row, I want the next row to "unhide" and the
cursor/selection placed on the first cell in this next row. How can I
accomplish this?

Thanks!

Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 18 Then Exit Sub
Rows(Target.Row + 1).Hidden = False
Cells(Target.Row + 1, 1).Select
End Sub

 

[Jim Cone]

Garry,

RE: "However, if you simply want to emulate a new
input row to 'appear' after entries in the last row are made, there are
ways to accomplish this using Conditional Formatting and sheet
protection to manage navigation."

OK, I give up - how do you do the above?
'---
Jim Cone



"GS" <[email protected]>
wrote in message

 

[GS]

Jim Cone wrote on 4/13/2012 :

OK, I give up - how do you do the above?

Jim,
If you have 'Professional Excel Development' by Bullen, Bovey, Green
there's an example in Chapter4 Worksheet Design. If you don't have the
book it will not be easy to explain how here unless I paste the entire
example into a post. (I don't think doing that would be appropriate<g>)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Jim Cone]

Thanks for the lead, I will see what I can find.



"GS" <[email protected]>
wrote in message

 

[GS]

Jim Cone was thinking very hard :

Thanks for the lead, I will see what I can find.



"GS" <[email protected]>
wrote in message

Best wishes!
Let me know if I can be of any further assistance...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion