View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saucer Man Saucer Man is offline
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 ---