LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 54
Default How do I unhide a row when ENTER is pressed in a certain cell?

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 ---
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When enter key is pressed, cursor does not move to next cell in Ex Blackie Excel Discussion (Misc queries) 3 April 19th 23 02:10 PM
how do I change which cell becomes active when enter is pressed? scotpiper Excel Discussion (Misc queries) 1 April 7th 09 12:18 AM
How to code: If active cell is B1, goto H17 when enter pressed GregBeam Excel Programming 2 November 26th 07 10:00 AM
Enter button jumps to next cell each time its pressed!!!! evasmagacz Excel Discussion (Misc queries) 3 June 17th 07 08:37 PM
Rounding up to nearest 10 when "Enter" is pressed or user has clickedoff the cell Maddoktor Excel Programming 2 January 16th 07 11:19 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"