copying macroassigned shape one

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying Macro-assigned shape from one workbook to another

Copying Macro-assigned shape from one workbook to another

resolvedResolved · Medium Priority · Version 2010

Matt has attended:
No courses

Copying Macro-assigned shape from one workbook to another

Please first state which Training Course this forum post is about: Excel VBA

I am trying to create a Master file with all our companies needed Macros into one excel file. I'm trying to get it where each Macro is assigned to its own shape so that all people have to do is open the spreadhsheet, copy the needed shape into their own spreadsheet and click on it. I do not want them to have to mess around with any visual basic editor or inserting modules. I am trying to make the process as easy for them as possible.

Does anyone know how to do this or if it is even possible?

Thanks,
Matt

RE: Copying Macro-assigned shape from one workbook to another

Hi Matt,

Thank you for the forum question.

I normally tell my clients that everything is possible in Excel, but this one I cannot help you with.

You can create VBA code from a VBA code but not by copy and paste.

See link below how to create VBA code from a VBA code:

https://stackoverflow.com/questions/34837006/excel-vba-add-code-to-sheet-module-programmatically


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 19 Oct 2017: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.07 secs.