Code to create Macro Button and Assigning Macro code

Hello:

Please refer to attached file.

i have below code which successfully create a macro button and assign the macro correctly.
This is only doing for one sheet and i need to modify the code so that it does for all sheets of the workbook.

Please Login or Register  to view this content.

Let me know if you have any questions.
Thanks.

Riz

Hi Riz,

An unrelated comment that may help you in the future after looking at your code:
To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx


Nice job Holger.

Lewis

Hi HiHoBe:

Your code works great.
Thanks a lot for such a great help.
Riz