Write and assign macro to newly created button using macro

**tryingtolearn** · 05-18-2012, 11:54 PM

I have attached a sample workbook with the code I am using. It works well, but now I need to have it write the macro to open the new sheet and assign the macro to the button it has just created. Can anyone help please.

**Andy Pope** · 05-19-2012, 05:34 AM

You need to set the OnAction property of the newly created button. You get this to run an existing macro which takes part of the buttons name to determine which sheet to activate.

Add this routine to a standard code module.

Please Login or Register  to view this content.

Alter you code

Please Login or Register  to view this content.

Not all names will result in valid sheetnames so you may need to handle that

**tryingtolearn** · 05-19-2012, 10:41 PM

Works perfectly. Thank you Andy.

Write and assign macro to newly created button using macro

LinkBack

Thread Tools

Rate This Thread

Display

Write and assign macro to newly created button using macro

Re: Write and assign macro to newly created button using macro

Re: Write and assign macro to newly created button using macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions