button position

  • Thread starter Thread starter Peter Andrews
  • Start date Start date
P

Peter Andrews

Is it possible to 'lock' the position of a button created using Control
Toolbox so that it remains on the screen when scrolling down a spreadsheet.
I want the user to be able to select a cell and then simply press the button
to carry out a task on the selected cell.

Thanks,

Peter
 
It may be easier to put the button in Row 1,
then select row 2,
then use windows|freeze panes
so that row 1 is always visible.
(Increase the rowheight so that the button fits nicely)
 
Dave Peterson said:
It may be easier to put the button in Row 1,
then select row 2,
then use windows|freeze panes
so that row 1 is always visible.
(Increase the rowheight so that the button fits nicely)
Click to expand...

Thanks, that looks an ideal solution for what I want to do.

Peter
 
Back
Top