View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default 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