Garry,

"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"
wrote in message
...
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 ---

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