Shamil

If you put code in the click even of the buttuon it will execute when you
click the button ! just as it would on a user form


Best N10


"SHamil3864" wrote in message
...
Hi N10,
Thanks for your quick reply.

Once I put remove the col letters and row numbers and put a command
button
on the spreadsheet and put code in the click event of the command button
how
do I execute the code. I am familiar with how to do this using a form
created with the visual basic editor and running it from there but don't
know
how to execute controls from a spreadsheet.

Thanks again,
Sterling

"N10" wrote:


"SHamil3864" wrote in message
...
Hi,
I would like to be able to use an excel spread sheet to appear as a
form
without the col letters and row numbers. Also, can I put controls on a
spreadsheet(ie command button) to be used with VBA code and if so can
you
point me to an example?

Many thanks,
Sterling Hamilton

HI

ActiveWindow.DisplayHeadings = False

That turns of the rows and colums, obviously in a macro.


You can add buttons to any sheet by displaying the visual basic tool bar
and there in finding the tool box. From the tool box you can drag buttons
etc to the form.

In design mode right click your buttons to gain access to the click
event
in the VBE.

Best n10