ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reverse Macro after it has run (https://www.excelbanter.com/excel-discussion-misc-queries/188153-reverse-macro-after-has-run.html)

Mike

Reverse Macro after it has run
 
I have successfullu run a Macro to hide certain rows that have zero sum
value, however I need guidance in being able to refresh my page once this has
been down. In order words, beside unhiding the rows that have been hidden to
start over, how can I reverse my Macro?

Thank you

Gary''s Student

Reverse Macro after it has run
 
Unhide them:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 5/20/2008 by James Ravenswood
'

'
Cells.Select
Selection.EntireRow.Hidden = False
End Sub



--
Gary''s Student - gsnu200787


"Mike" wrote:

I have successfullu run a Macro to hide certain rows that have zero sum
value, however I need guidance in being able to refresh my page once this has
been down. In order words, beside unhiding the rows that have been hidden to
start over, how can I reverse my Macro?

Thank you


Mike

Reverse Macro after it has run
 
Worked! Thanks

"Gary''s Student" wrote:

Unhide them:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 5/20/2008 by James Ravenswood
'

'
Cells.Select
Selection.EntireRow.Hidden = False
End Sub



--
Gary''s Student - gsnu200787


"Mike" wrote:

I have successfullu run a Macro to hide certain rows that have zero sum
value, however I need guidance in being able to refresh my page once this has
been down. In order words, beside unhiding the rows that have been hidden to
start over, how can I reverse my Macro?

Thank you



All times are GMT +1. The time now is 07:17 PM.

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