excel: capture worksheet rename event

[y2k1981]

please, can somebody help me out here. I'll try to explain as best I can. i need to capture the worksheet rename event, because it needs to update another worksheet (called lookups). When the workbook closes, it loops through all of the worksheet names in the "lookups" sheet and hides any sheets who'se names are there. So if somebody renames it, the lookups sheet needs to be changed to reflect the new name. Can somebody help me out here?

Sorry, I don't think I explained that very well, but hopefully somebody can help????

 

[Loomah]

Hi
I had a quick look at this and can't come up with a solution in the time I have. What I'd recommend is reposting to the VBA forum (forum707) if you haven't already done so.

Good luck
;-) If a man says something and there are no women there to hear him, is he still wrong?