Buttons on worksheets

Hi everyone

I have a ms spreadsheet with a "search" and a "clear" button on it. But when i press the search button to get info from a SQL Server database part of the info on the spreadsheet is covered by the buttons. I know this is no big deal, as the cells can be moved/stretched, but it would be more user friendly to my users if this was not the case.

Is there a way to place the buttons on the worksheet so that they don't interfere with the data being displayed.

Thanks guys

Dave

Why not create toolbar buttons and assign your macros to them?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"David494" <David494.1svgyn_1122541778.0846@excelforum-nospam.com> wrote in
message news:David494.1svgyn_1122541778.0846@excelforum-nospam.com...
>
> Hi everyone
>
> I have a ms spreadsheet with a "search" and a "clear" button on it.
> But when i press the search button to get info from a SQL Server
> database part of the info on the spreadsheet is covered by the buttons.
> I know this is no big deal, as the cells can be moved/stretched, but it
> would be more user friendly to my users if this was not the case.
>
> Is there a way to place the buttons on the worksheet so that they don't
> interfere with the data being displayed.
>
> Thanks guys
>
> Dave
>
>
> --
> David494
> ------------------------------------------------------------------------
> David494's Profile:
http://www.excelforum.com/member.php...o&userid=24482
> View this thread: http://www.excelforum.com/showthread...hreadid=390867
>

hi,
you can do what i do.
but the button at the very top of the sheet.
size the title row to the size of the button and size coulumn the button is
in to the width of the button. so the the button seem to occupy the cell.
(you can do this with code and add it to the end of the macro as a "tidy up"
messure."
then for button caption..give it the column title.
this way the button blends into the data. sort of.

Regards

FSt1

"David494" wrote:

>
> Hi everyone
>
> I have a ms spreadsheet with a "search" and a "clear" button on it.
> But when i press the search button to get info from a SQL Server
> database part of the info on the spreadsheet is covered by the buttons.
> I know this is no big deal, as the cells can be moved/stretched, but it
> would be more user friendly to my users if this was not the case.
>
> Is there a way to place the buttons on the worksheet so that they don't
> interfere with the data being displayed.
>
> Thanks guys
>
> Dave
>
>
> --
> David494
> ------------------------------------------------------------------------
> David494's Profile: http://www.excelforum.com/member.php...o&userid=24482
> View this thread: http://www.excelforum.com/showthread...hreadid=390867
>
>