Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moved macros to new book now they don't work
This is my third attempt to post this problem. My apologies for any
duplication. I moved some macros to a new workbook (Excel 2003), so they could be shared amongst multiple workbooks. In order to run the code in the new location, I changed the worksheet_activate sub in the originating sheet as follows: from Call Macro1("Parm1") to Application.Run "'_Workbook2.xls'!Macro1(""Parm1"")" Now some of the code doesn't work. For example: With Worksheets("Sheet1") .Columns("A:I").ClearContents ' does nothing .Cells(10, 3) = "line 1" ' works End With Any suggestions would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moved code to new book - some doesn't work now | Excel Programming | |||
moved macros to new book, now not working | Excel Programming | |||
Moved file, changed path, macros don't work | Excel Programming | |||
Maintaining a hyperlink to moved data within the work book | Excel Discussion (Misc queries) | |||
Macros - get information from Multiple sheets in a work book? | Excel Programming |