Thanks. But I like to create the button on the fly from VBA only.
For example, when the book is open, it will invoke a routine to
loop through all the worksheets's name start with "ABC" and
place a button on it, including assign a macro to it.

AC

"Gary''s Student" wrote:

1. View Toolbars Forms
2. click on the Button button
3. draw the button on the sheet
4. assign a macro to the button
--
Gary''s Student - gsnu200820


"AndrewCerritos" wrote:

Hi, could anybody give me some hint or example on
how to create button on the fly on a worksheet?

AndrewCerritos