How do I create macros which will stay on the workbook it is created in?

  • Thread starter Thread starter jdtivoli
  • Start date Start date
J

jdtivoli

I have a workbook which I have created and stored on a server fo
multiple users to access. There needs to be macros to be used by al
who access this workbook.

The only way that I have been able to get the macros to work is to sav
them in the Personal.xls spreadsheet and then copy this spreadsheet t
each user's pc.

I would like to have the macros attached to only the workbook whic
uses them and still have it stored and available for all to use fro
the server.

Whenever I have tried to attach the macros to the workbook, the nex
time I open the workbook they are gone.

Help please,

Jess
 
when you make a macro you get 3 choices to save a macro. (persona
macromap,new map, this map).
i think you make the wrong choices in the beginning. for the macro yo
want , you must choose "this map"
have you work in VBA??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating macro to use on different workbooks 1
Using a macro to create a macro 1
how to prevent macros in Personal.xls appearing in other workbook 3
Vista problem with NO Personal Macro Workbook in Startup Folder 6
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
sending a macro to another person 1
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Hot Do I Send macros with Excel Workbooks? 4

Back
Top