I have a spreadsheet where I want to be able to create a macro button to hide a column when the sum of a row is zero.
I tried following the code to a similar question posted at (http://www.excelforum.com/excel-prog...itionally.html), but I couldn't get the code to work after trying to modify it to my specifications.
Hopefully this attachment works (first time poster), it is just one of the tabs I would like to apply it on.
Attachment 215817
What I would like to be able to do is click a macro to hide a column from E through AO to be hidden if the value in Row 31 is zero to clean the sheet up.
If anyone has any incite or could build off the related post, I would really appreciate the help.
Thanks
Bookmarks