code wont run or start

[SPARKY347]

think someone can give me a hand I cant seem to get this code to fire, any chaNCE I'm missing something?

Please Login or Register  to view this content.

[Philb1]

Hi
The macro fires if it's in a worksheet module, but throws errors.
Post a sample workbook of what you have so we can see what you're trying to achieve

Phil

[SPARKY347]

see attached i put it in the workbook module as i would like it to fire on every sheet

[MarvinP]

Hi Sparky,

Put your code in a Module with a name like "FireMe". Then behind each sheet on the Worksheet_Activate event, Call FireMe. I think that is what you are trying to do. Code behind each sheet can only work on/in that individual sheet. Code in a module can work across sheets.

I think the problem lies within this page:
http://www.cpearson.com/excel/codemods.htm