Where to put procedures

[DChambers]

What is the difference where prcedures are placed? worksheets, this workbook, modules etc. Any links that I can look at?

 

[Jonmo1]

The main difference is...

Event code (like change,calculate,selection_change) goes in the Sheet or thisworkbook module.
Everything else goes in standard modules.

I'm sure there's more, but that's basically it..

 

[DChambers]

Jonmo1,

What if I wanted to write a procedure that could only be used when a specific workbook is open? Put it in the "ThisWorkbook" area?

Lets say I want to copy a sheet from another workbook and put it into a newly created sheet in ThisWorkBook. Would it have to reside in the thisworkbook or could I put it into an existing sheet (I dont know why - just an example)?

 

[Jonmo1]

What if I wanted to write a procedure that could only be used when a specific workbook is open? Put it in the "ThisWorkbook"

Any code can only be used when that workbook is open..
Except Addins

 

[DChambers]

I guess I was thinking about personal.xls which is where I put most of my code. I asked thinking that I could send the workbook and have the procedure embedded in it instead of having to move it from my personal.xls to theirs.

 

[Jonmo1]

You should consider making and distributing an Addin. so your code will be available to everyone..

http://www.cpearson.com/excel/AutomationAddIns.aspx

 

[DChambers]

Only problem I see with Addins are that they must be installed on each computer that uses them. My workbooks go to upper management all over the world & upper management can barely open a workbook much less go to tools etc...- you should have heard the phone calls and seen the amount of EMail I recieved when I first put a macro into a spreadsheet and the security level on their machines was such that it put up a warning, talk about *PANIC*

 

[Jonmo1]

Well if that's the level of expertise, then you're gonna have problems no matter what you do....

 

[DChambers]

True..True...

 

[Fazza]

Darrell.

If you're at Chip's site ... http://www.cpearson.com/excel/codemods.htm

HTH, Fazza