Add Command Button

**Sniper** · 10-15-2009, 08:58 AM

I want to write a code that adds a commandbutton to a sheet. i have already a macro that will hide the active book and go to the main sheet - i need that same commandbutton to be able to call macro1. Please Help

**royUK** · 10-15-2009, 09:18 AM

Where do yo want to add this button - a new workbook?

Why is it necessary to add the commandbutton with code.

**Sniper** · 10-15-2009, 09:20 AM

needs to be added in new sheet, i want to be able to close the sheet and hide it , i have a form witch looks up the sheets if i want to load them again.

**royUK** · 10-15-2009, 10:34 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!