Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ensure a macrow will save in Excel?
I have created a macro to sort and format in Excel and it works fine on my PC
but when I tried to create the same macro on someone else's PC, it wouldn't save. Could there be something missing in her setup? If so, what is it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ensure a macrow will save in Excel?
Make sure that when you install the macro in the user's system that it goes
in a module within the workbook, not an external file like personal.xls -- Gary''s Student - gsnu200769 "Tigger59" wrote: I have created a macro to sort and format in Excel and it works fine on my PC but when I tried to create the same macro on someone else's PC, it wouldn't save. Could there be something missing in her setup? If so, what is it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ensure a macrow will save in Excel?
If you are creating the macro within a workbook, simply save the workbook.
If you are creating in personal.xls, create a personal xls first by simply recording any macro to personal.xls. Excel will create it for you. -- Don Guillett Microsoft MVP Excel SalesAid Software "Tigger59" wrote in message ... I have created a macro to sort and format in Excel and it works fine on my PC but when I tried to create the same macro on someone else's PC, it wouldn't save. Could there be something missing in her setup? If so, what is it? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ensure a macrow will save in Excel?
I tried that, however, the second person who responded to my macro inquiry
said the exact opposite of what you said. Now I'm confused. Could it be something in the Excel or Microsoft Office setup that I have and she doesn't? "Gary''s Student" wrote: Make sure that when you install the macro in the user's system that it goes in a module within the workbook, not an external file like personal.xls -- Gary''s Student - gsnu200769 "Tigger59" wrote: I have created a macro to sort and format in Excel and it works fine on my PC but when I tried to create the same macro on someone else's PC, it wouldn't save. Could there be something missing in her setup? If so, what is it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I ensure i dont do typo errors with name entries in excel? | Excel Discussion (Misc queries) | |||
Ensure Excel goes to last used cell upon startup | Excel Discussion (Misc queries) | |||
how do i ensure people use the right date format in excel? | Excel Worksheet Functions | |||
How can I ensure #records in a selected set always shows in Excel | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |