ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unhide rows in an Excel Macro (https://www.excelbanter.com/excel-programming/441964-unhide-rows-excel-macro.html)

Notar

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!)


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com