Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that copiesother macros to a new workbook
I am aware of one VBA method for copying a worksheet and it's local macros
to a new workbook. In short, it uses Export and Import commands that temporarily dis-associate the macro from the worksheet. The problem arises if the worksheet uses macro hot spots. When the spreadsheet and its macros are reunited in the new workbook, the hot spot assignment (pointers) are not automatically updated. Thus they do not find the local macro because the path has changed. Keyboard activation of the macros and drop-down menus work fine, so the problem is with hot spots and not the macros I've tried numerous ideas to automatically relink the hot spots and macros via another macro. But worksheet_activate(), error messages and other Excel events interact with the copying macro and haven't worked. Is there another general VBA technique for copying a worksheet and its associated macros? .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't find macros in a macro-enabled workbook | Excel Programming | |||
Unwanted Macro Warning for workbook containing no macros | Excel Discussion (Misc queries) | |||
Calling up the macro dialog to list stored macros in a workbook-VB | Excel Programming | |||
callin the macro dialog to list all stored macros in a workbook VB | Excel Programming | |||
Macro warning when no macros in workbook | Excel Programming |