Put in a split screen with the small area at the bottom. Scroll you button
into view in the bottom pane.

Window=split, then drag the verticle bar to one side and drag the
horizontal bar toward the bottom

--
Regards,
Tom Ogilvy


"avveerkar" wrote
in message ...

Bob Phillips Wrote:
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

Thanks Bob. What you are suggesting is to have a button on Tools Bar
which will be only made " Enabled True " when my particular sheet is
activated. That way it will be hidden when any other sheet is
displayed. But is it just not possible to put a button ON THE SHEET
and see that it does not move up as the sheet is scrolled down? My
application will be much better if I can put the button somewhere at
the bottom which will not move up as I scroll the sheet. My application
requires me to scroll down to a particular row, select the cell of
interest and then press a button to modify the cell selected. Since I
always scroll down to look for particular cells, my mouse pointer is
always at the bottom right corner on scroll bar. I would like to have
the button placed at the bottom right corner of the sheet where I can
easily go and click and come back to the scroll bar.
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