I have a macro that when i click on it - it unhides some sheets to modify them and then hides them again when it is done. I want to be able to make it so it will recognize if the sheets are already hidden or not.
I need a macro that IF the sheet is hidden... continue on and unhide it... then hide it after all alterations are made... but IF the sheet isnt hidden... just ignore the rest and make the alterations...
How would i write this out?
i appreciate any suggestions and help - thanks!
I need a macro that IF the sheet is hidden... continue on and unhide it... then hide it after all alterations are made... but IF the sheet isnt hidden... just ignore the rest and make the alterations...
How would i write this out?
i appreciate any suggestions and help - thanks!