View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default How to turn off the row # and col letters to create an excel form


"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