Chadwick
02-11-2006, 03:32 AM
Hello,
My Sister told me to come here and learn. I think she is tired of my questions! I am sure this can be done!
Just learning to use the macro recorder and made 2 macros. The 1st will "hide" columns E, F, G and the 2nd will "unhide the columns.
The file is attached as it may help.
I am trying to find an answer to this,
When I select the ?Heats? option, the hide macro is run and Cells E7, F7, G7 in row 7 and cells E8, F8, G8 in row 8 are no longer visible.
I don?t want those cells to be hidden.
What changes need to be made to the hide macro to keep the cells above visible at all times like they are when the ?Training & Heats? option is selected? :dunno
I can put cells some place else but I want to see how this is done and try to understand the code.
Could someone show me how to begin and I will go away and work on it myself...
Thank you very much,
Cliff Chadwick
My Sister told me to come here and learn. I think she is tired of my questions! I am sure this can be done!
Just learning to use the macro recorder and made 2 macros. The 1st will "hide" columns E, F, G and the 2nd will "unhide the columns.
The file is attached as it may help.
I am trying to find an answer to this,
When I select the ?Heats? option, the hide macro is run and Cells E7, F7, G7 in row 7 and cells E8, F8, G8 in row 8 are no longer visible.
I don?t want those cells to be hidden.
What changes need to be made to the hide macro to keep the cells above visible at all times like they are when the ?Training & Heats? option is selected? :dunno
I can put cells some place else but I want to see how this is done and try to understand the code.
Could someone show me how to begin and I will go away and work on it myself...
Thank you very much,
Cliff Chadwick