Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to save my VBA-code
Hello,
I made a small code in VBA. But when my colleague open the spreadsheet he canīt use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to save my VBA-code
Can you use the code when you open the spreadsheet?
Heine wrote: Hello, I made a small code in VBA. But when my colleague open the spreadsheet he canīt use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to save my VBA-code
No, when I change my input data nothing happens. Is it due to the fact
that I saved it in my personal.xls? CurlyDave wrote: Can you use the code when you open the spreadsheet? Heine wrote: Hello, I made a small code in VBA. But when my colleague open the spreadsheet he canīt use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to save my VBA-code
Save it in the workbook you gave to your friend
-- Don Guillett SalesAid Software "Heine" wrote in message ups.com... Hello, I made a small code in VBA. But when my colleague open the spreadsheet he canīt use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to save my VBA-code
When you save the code in your Personal.xls the other users do not have access
to the code. Save the code in the workbook and your colleagues can use it. Gord Dibben MS Excel MVP On 26 Sep 2006 03:40:56 -0700, "Heine" wrote: No, when I change my input data nothing happens. Is it due to the fact that I saved it in my personal.xls? CurlyDave wrote: Can you use the code when you open the spreadsheet? Heine wrote: Hello, I made a small code in VBA. But when my colleague open the spreadsheet he canīt use my code. Where do I want to save my code, if I want everybody to have access? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Save As Code??? | Excel Worksheet Functions | |||
t-distribution puzzle in Excel | Excel Discussion (Misc queries) | |||
Code to save info to another column? | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |