Re: Modifying list making macro to tie comment cells to proper list name cell. No row
I always want make, edit, delete comments in first sheet(Sheet List). But it seems, comments has to be stored somewhere else and called back from that place.
What about to store them in each sheet macros ? Somebody told me to make some Public function(in each sheet ?), which gives back that text into first sheet.
But it would be ineffective to make manually macro for each sheet. Is possible to make overall macro to make automatically other smaller macros ? Also when I add new sheet, that overall macro, would make into new sheet that particular one.
Would be anyone so kind to code it ?