View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to keep the button visible always in the screen, thanks

One way: Put the button within cell A1 and freeze panes at cell B2

For example:

Click on B2, then click Window Freeze Panes

Widen col A & row1 large enough to accommodate the button within cell A1

Place the button within cell A1

It'll always stay in view whether you scroll down / to the right
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Kortrijker" wrote in message
...
Dear all,

Is there any way to keep a button, which is created in excel sheet ,

always
visible in the screen.

for instance, I create a button directly from toolbar/form/button in excel
sheet, I want to keep this button always stays in the fixed position
whereever I scroll this sheet. Can I realize it or it's impossible.

Thanks
JIANG