ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   custom views / macros (https://www.excelbanter.com/new-users-excel/220256-custom-views-macros.html)

Khardy3352

custom views / macros
 
In creating a custom view from a master document, I manually hid every third
row for 1000 rows (whew), assigned a custom view name, added a macro to to
show only a particular heading for that view, and assigned a shortcut
(cntrl-L). The worksheet was saved as a template. The file was then resaved
with a new name and cells filled with desired info. Pressing cntrl-L worked a
few times, then suddenly, the view no longer had every third row hidden,
though the heading macro still worked.

1. I don't know why it suddenly stopped working and

2. can you help me write a macro that hides every 3rd row automatically?


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

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