How to get macro in new workbook

[PaulS]

Hope one of the experts has a solution for my problem.
I have made a macro to run on a databasesheet.
This sheet is made by opening a csv file, that has been created by an administrative system. Most users have no knowledge of excel other than seeing this as a list of data to work on. However this file has to many lines. The macro creates a new sheet with an extract for that particular user.
Klicking on a csv file will open a new Excel sheet. My problem is how do I get the macro to work on that new database? This of course via a simple action to be perfomed by the enduser.
Thanks for your help,
Paul

 

[Weaver]

You could look at creating a personal macro workbook (personal.xls) for that user and then storing the macro within this workbook rather than the current one. That way, the macro (and any others you might choose to store there) will be available each time the user opens Excel.

You can create a personal.xls by recording a simple macro and in the 'record macro' dialog, set the 'store macro in' dropdown to 'personal macro workbook'.

HTH