| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ocde in a different workbook
Hi
I created some VBA code ina spreadsheet, and then renamed the spreadsheet, and now whenever I try to run the macros it looks for them in the original spreadsheet. I have tried deleting the module and then inserting a new one and pasting the code back in, but nothing seems to work. HELP!!! TIA Terry == Terry Freedman www.ictineducation.org |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ocde in a different workbook
Terry,
How are you calling the code? From a commandbutton, or ActiveX control, MS Form, or through other code? Where does the code reside? HTH, Bernie MS Excel MVP "terry freedman" wrote in message ... Hi I created some VBA code ina spreadsheet, and then renamed the spreadsheet, and now whenever I try to run the macros it looks for them in the original spreadsheet. I have tried deleting the module and then inserting a new one and pasting the code back in, but nothing seems to work. HELP!!! TIA Terry == Terry Freedman www.ictineducation.org |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ocde in a different workbook
On Tue, 4 May 2004 21:00:20 -0400, "Bernie Deitrick" <deitbe @
consumer dot org wrote: Terry, How are you calling the code? From a commandbutton, or ActiveX control, MS Form, or through other code? Where does the code reside? Hi, Bernie I wrote the code in the VBA section (ie alt-F11), and am calling it from both a custom menu and a command button (well, actually a shape with a macro assigned to it) Thanks Terry HTH, Bernie MS Excel MVP "terry freedman" wrote in message .. . Hi I created some VBA code ina spreadsheet, and then renamed the spreadsheet, and now whenever I try to run the macros it looks for them in the original spreadsheet. I have tried deleting the module and then inserting a new one and pasting the code back in, but nothing seems to work. HELP!!! TIA Terry == Terry Freedman www.ictineducation.org == Terry Freedman www.ictineducation.org |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ocde in a different workbook
Terry,
You will need to open your new workbook, then change the onaction properties of both the commandbutton (right-click on any commandbar, choose Customize..., then right click on the button and choose Assign Macro...) and the shape (using r-click, Assign macro...) to the macro again. HTH, Bernie MS Excel MVP "terry freedman" wrote in message ... On Tue, 4 May 2004 21:00:20 -0400, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Terry, How are you calling the code? From a commandbutton, or ActiveX control, MS Form, or through other code? Where does the code reside? Hi, Bernie I wrote the code in the VBA section (ie alt-F11), and am calling it from both a custom menu and a command button (well, actually a shape with a macro assigned to it) Thanks Terry HTH, Bernie MS Excel MVP "terry freedman" wrote in message .. . Hi I created some VBA code ina spreadsheet, and then renamed the spreadsheet, and now whenever I try to run the macros it looks for them in the original spreadsheet. I have tried deleting the module and then inserting a new one and pasting the code back in, but nothing seems to work. HELP!!! TIA Terry == Terry Freedman www.ictineducation.org == Terry Freedman www.ictineducation.org |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ocde in a different workbook
thanks, Bernie
On Wed, 5 May 2004 08:25:04 -0400, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Terry, You will need to open your new workbook, then change the onaction properties of both the commandbutton (right-click on any commandbar, choose Customize..., then right click on the button and choose Assign Macro...) and the shape (using r-click, Assign macro...) to the macro again. HTH, Bernie MS Excel MVP "terry freedman" wrote in message .. . On Tue, 4 May 2004 21:00:20 -0400, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Terry, How are you calling the code? From a commandbutton, or ActiveX control, MS Form, or through other code? Where does the code reside? Hi, Bernie I wrote the code in the VBA section (ie alt-F11), and am calling it from both a custom menu and a command button (well, actually a shape with a macro assigned to it) Thanks Terry HTH, Bernie MS Excel MVP "terry freedman" wrote in message .. . Hi I created some VBA code ina spreadsheet, and then renamed the spreadsheet, and now whenever I try to run the macros it looks for them in the original spreadsheet. I have tried deleting the module and then inserting a new one and pasting the code back in, but nothing seems to work. HELP!!! TIA Terry == Terry Freedman www.ictineducation.org == Terry Freedman www.ictineducation.org == Terry Freedman www.ictineducation.org |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Hybrid Mode
