Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Source is Changing
I have a workbook called Inventory.xlsm. This has several macros which are
selected with a button. One of them is "PO" which creates a Purchase Order based on items selected in the Inventory workbook. The button is assigned to the macro Inventory.xlsm!PO The macro creates a new workbook called c:\mypath\NewPO.xlsx and saves the file and closes c:\mypath\NewPO.xlsx This all works - the file is created successfully. However, at this point all macro buttons in Inventory.xlsm have been reassigned so that I can't run them. For example, the PO button is now assigned to c:\mypath\NewPO.xlsx!PO. Any ideas are appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM of Changing source value, pls help!!! | Excel Discussion (Misc queries) | |||
Changing Data Source | Excel Worksheet Functions | |||
Changing the source of a link | Excel Discussion (Misc queries) | |||
Changing the source of links. | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions |