Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Unhide rows in an Excel Macro

The worksheet has 120 rows required for data entry - this takes place
in 4 row increments.

(Row 1 is an Information row - no data input) Data input begins on
row 2.

The worksheet is protected except for specific cells.

So, leaving the first 4 rows available for input, and the remaining
rows hidden, I need a macro that will execute after the last cell has
been input, and the enter key pressed, that will display the next 4
rows.

The macro must terminate execution after row 121 has been displayed as
there is more information and calculations that occur in the rows
following.

Thanks - I have been pulling my hair out on this one (and don't have
much to start with!)
Reply
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
Code to Unhide Rows using Macro Rajat Excel Worksheet Functions 7 January 14th 10 06:56 PM
Unhide rows macro GoBucks[_2_] Excel Programming 2 May 20th 09 07:09 PM
Macro to Unhide Rows RLY Excel Programming 4 April 13th 09 07:02 PM
Macro that will unhide then hide rows minka Excel Discussion (Misc queries) 10 October 21st 06 01:37 PM
How do I hide or unhide zero value columns/rows USING A MACRO? paul Excel Discussion (Misc queries) 1 January 23rd 06 03:06 PM


All times are GMT +1. The time now is 11:22 AM.

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"