Code runs through xlsm source workbook but not through the add-in button?

**immigrated4urjob** · 08-20-2021, 07:12 AM

Using same workbook and applying two different methods:

• Using macro in the xlsm file - works OUTCOME: copies all table ranges and chart objects into separate PPT objects as expected
• Using macro through add - in button - fails | OUTCOME: creates an empty PPT slide, and finishes the macro

Please Login or Register  to view this content.

**davesexcel** · 08-20-2021, 07:24 AM

Maybe the Addin should change to ActiveWorkbook in place of ThisWorkbook

**immigrated4urjob** · 08-20-2021, 07:43 AM

Originally Posted by davesexcel

Maybe the Addin should change to ActiveWorkbook in place of ThisWorkbook

Absolute legend mate. This will go in my diary of more silly errors.

Code runs through xlsm source workbook but not through the add-in button?

LinkBack

Thread Tools

Rate This Thread

Display

Code runs through xlsm source workbook but not through the add-in button?

Re: Code runs through xlsm source workbook but not through the add-in button?

Re: Code runs through xlsm source workbook but not through the add-in button?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to open source workbook and save as .xlsm format

Trying to assign macro button that runs on a different sheet in the workbook

Code runs with F8 but not from button

[SOLVED] Copy/Save As xlsm workbook to new xlsm workbook is not copying the code with it

Ok button runs code 17 times w/o loop.... Why?

[SOLVED] code behind the command button that runs another macro

Excel - keep a command button from moving after code runs?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions