| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button on a sheet always visible
Normally the command button I place on a sheet to start a micro rolls out of the window as I scroll the sheet ( button also moves up as the rows move up when I scroll the sheet ). Is there any way to lock a button in a window so that it is always available no matter to what rows the sheet is scrolled? A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
Hi
Use Freeze Panes to freeze row(s) where the button is placed. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "avveerkar" wrote in message ... Normally the command button I place on a sheet to start a micro rolls out of the window as I scroll the sheet ( button also moves up as the rows move up when I scroll the sheet ). Is there any way to lock a button in a window so that it is always available no matter to what rows the sheet is scrolled? A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
You could always put the button in the first few rows, then freeze a pane
(WindowFreeze Panes) below that button. Or you could add a button to a toolbar. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "avveerkar" wrote in message ... Normally the command button I place on a sheet to start a micro rolls out of the window as I scroll the sheet ( button also moves up as the rows move up when I scroll the sheet ). Is there any way to lock a button in a window so that it is always available no matter to what rows the sheet is scrolled? A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
Thanks for your responses. But for design reasons I want to have m buttons placed at the bottom of the displayed sheet. Cannot lock botto rows to freeze pane. Yes button in menu bar is an option but it woul then appear in all sheets of the workbook. I would prefer a comman button on a sheet, at the bottom and it stays put where it is locate and not move with scrolling. A V Veerka -- avveerka ----------------------------------------------------------------------- avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033 View this thread: http://www.excelforum.com/showthread.php?threadid=50005 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
You can program a menu to disappear when you select another sheet and appear when you select the initial sheet. -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
You could add code to your workbook to show that button when that workbook
is activated or opened, hide it when deactivated or closed. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "avveerkar" wrote in message ... Thanks for your responses. But for design reasons I want to have my buttons placed at the bottom of the displayed sheet. Cannot lock bottom rows to freeze pane. Yes button in menu bar is an option but it would then appear in all sheets of the workbook. I would prefer a command button on a sheet, at the bottom and it stays put where it is located and not move with scrolling. A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
Bob Phillips Wrote: You could add code to your workbook to show that button when that workbook is activated or opened, hide it when deactivated or closed. -- HTH Bob Phillips Dear Bob, Can you clarify? I code my workbook ( you mean worksheet ) to show button when it is activated - how does that help? Sorry, I am missing the point. As I select the sheet, my code will display the button where I want it but how do I lock it in that position? It will still move up when I scroll the sheet. Are you suggesting that I should deactivate the sheet and activate it again so that the button is re-displayed ( by, let us say, selecting other sheet and then coming back to this sheet )? I still don't understand how this will help. I appreciate your spending time on this. A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button on a sheet always visible
Yes, in your case I mean sheet. Something like
Private Sub Worksheet_Activate() Application.CommandBars("Formatting").Controls("my Button").Enabled = True End Sub Private Sub Worksheet_Deactivate() Application.CommandBars("Formatting").Controls("my Button").Enabled = False End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "avveerkar" wrote in message ... Bob Phillips Wrote: You could add code to your workbook to show that button when that workbook is activated or opened, hide it when deactivated or closed. -- HTH Bob Phillips Dear Bob, Can you clarify? I code my workbook ( you mean worksheet ) to show button when it is activated - how does that help? Sorry, I am missing the point. As I select the sheet, my code will display the button where I want it but how do I lock it in that position? It will still move up when I scroll the sheet. Are you suggesting that I should deactivate the sheet and activate it again so that the button is re-displayed ( by, let us say, selecting other sheet and then coming back to this sheet )? I still don't understand how this will help. I appreciate your spending time on this. A V Veerkar -- avveerkar ------------------------------------------------------------------------ avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338 View this thread: http://www.excelforum.com/showthread...hreadid=500050 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
| XL2003: control button not visible | Excel Programming | |||
| Visible Button If..... | Excel Programming | |||
| Make Command Button visible only in .xlt? | Excel Programming | |||
| how to keep the button visible always in the screen, thanks | Excel Programming | |||
Hybrid Mode
