formulae one sheet that appears in all new sheets

[jamiepullen]

firstly, thanks to 'mikerickson' who helped me on this one last time. lost the thread though and just want to ask if it is possible someone could help me.
i have a workbook that has three sheets, say 'sheet a', 'sheet b' and 'sheet c'
I want to be able to type formulae into 'sheet c' and have those formulae appear on any new sheets that are opened thereafter. Mikerickson kindly helped me on this and it worked well until i deleted the sheet by mistake

I am now a little more prepared and have a pen drive to back up any sheets i am playing around with!

The only change i wanted which i did not make clear before (sorry) was that i did not want the formulae to appear on the existing sheets (ie 'sheet a', and 'sheet b') and only on new ones created. Can anyone help me please?

On a different note, i am so impressed with the help i have got off of here i have decided to go down the self help route and start learning vb. I have a book which teaches at a pace i can handle (slow!), but was wondering if i am reading the right thing. Is there a difference between VBA for excel and VB, which is what i seem to be learning. if there is, is it easy to apply VB to VBA?

Any help on either of my questions would, as ever, be greatly appreciated

Regards,

Jamie

[jamiepullen]

just found mickericksons solution, as below if it helps. Can anyone help me change it so it does not affect existing sheets, only new ones on opening, or is there another solution?

If this routine in put in the ThisWorkbook code module, every time a sheet in the workbook is activated, the formula in Master sheet, cell G6 will be put in G6 of the newly activated sheet.
The name "Master" and "G6" should be modified to fit your particular situation.

Please Login or Register  to view this content.

Instalation instructions:
Open the VBEditor, View the ProjectExplorer, open the Microsoft Excel Objects folder, double click the ThisWorkbook icon, copy/paste the code into the window which will appear. Close the window, Exit the VBEditor and return to Excel.__________________