Hi
using Excel 2007

What is the difference between a Command Button and a Form Control Button?
What is the criteria used in choosing one over the other?

I use a Form Control Button in the Quick Access Toolbar that allows me to
quickly add a button onto the worksheet page and record a macro to "This
Workbook".

Am I correct in using the button this way?

It seems to works ok, but should I be using a different button/method.
I cleanup the recorded code to stop "select" happening where ever possible
and my knowledge of VBA allows.


--
Thank you

Bob C
It cost''''''''s little to carry knowledge with you.

What you are doing is fine. Forms buttons ae easy to set up. Another fun
thing to try is to first create the macro in a standard module. Then put any
AutoShape on the sheet. You can right-click the Shape and assign the macro
to it.

You can resize the Shape, color it, etc. Neater than a boring button.
--
Gary''s Student - gsnu200778


"Bob C" wrote:

Hi
using Excel 2007

What is the difference between a Command Button and a Form Control Button?
What is the criteria used in choosing one over the other?

I use a Form Control Button in the Quick Access Toolbar that allows me to
quickly add a button onto the worksheet page and record a macro to "This
Workbook".

Am I correct in using the button this way?

It seems to works ok, but should I be using a different button/method.
I cleanup the recorded code to stop "select" happening where ever possible
and my knowledge of VBA allows.


--
Thank you

Bob C
It cost''''''''s little to carry knowledge with you.