Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro - Create & Run
I have created an Excel Macro and saved as Personal Workbook Macro. I can
then run the macro provided I don't close Excel completely. However, once I close Excel and attempt to run macro it is no longer available. You input as to what I am doing wrong will be greatly appreciated. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro - Create & Run
I'm lost. You created an Excel macro. You put it in your personal workbook.
You closed Excel. Now you are trying to run the macro? How are you running the macro if Excel is closed? Are you trying to run it from another program? -- HTH... Jim Thomlinson "JMunoz" wrote: I have created an Excel Macro and saved as Personal Workbook Macro. I can then run the macro provided I don't close Excel completely. However, once I close Excel and attempt to run macro it is no longer available. You input as to what I am doing wrong will be greatly appreciated. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro - Create & Run
Were you prompted to save changes to Personal.xls when you closed Excel?
(You should have been). If so, unless you respond yes, then the workbook will not save the recorded macro and when you again open Excel, it will not be available. -- Regards, Tom Ogilvy "JMunoz" wrote: I have created an Excel Macro and saved as Personal Workbook Macro. I can then run the macro provided I don't close Excel completely. However, once I close Excel and attempt to run macro it is no longer available. You input as to what I am doing wrong will be greatly appreciated. Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro - Create & Run
I think he means the next time he opens a workbook in Excel.
-- Regards, Tom Ogilvy "Jim Thomlinson" wrote: I'm lost. You created an Excel macro. You put it in your personal workbook. You closed Excel. Now you are trying to run the macro? How are you running the macro if Excel is closed? Are you trying to run it from another program? -- HTH... Jim Thomlinson "JMunoz" wrote: I have created an Excel Macro and saved as Personal Workbook Macro. I can then run the macro provided I don't close Excel completely. However, once I close Excel and attempt to run macro it is no longer available. You input as to what I am doing wrong will be greatly appreciated. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
How do i create a hyerlink in my excel macro? | Excel Discussion (Misc queries) | |||
Need to create Excel Macro? | Excel Discussion (Misc queries) | |||
how do I create a macro in excel? | Excel Programming | |||
Macro to Create PDF from excel with filename... | Excel Programming |