Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- David494 ------------------------------------------------------------------------ David494's Profile: http://www.excelforum.com/member.php...o&userid=24482 View this thread: http://www.excelforum.com/showthread...hreadid=390867 |
#2
|
|||
|
|||
Why not create toolbar buttons and assign your macros to them?
-- HTH RP (remove nothere from the email address if mailing direct) "David494" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Worksheets | Excel Discussion (Misc queries) | |||
Buttons on excel worksheets relocating to the left when I print. . | Excel Discussion (Misc queries) | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |