Ask Your Question

how to make push button permanently visible while scrolling columns or rows ? [closed]

asked 2016-02-15 03:39:19 +0200

shma_lo gravatar image

I have push button on calc sheet. I need have this button visible and active permanently, but it disappears while I scroll rows or columns.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by shma_lo
close date 2016-03-05 20:07:46.803456

1 Answer

Sort by » oldest newest most voted

answered 2016-02-16 13:24:05 +0200

pierre-yves samyn gravatar image

updated 2016-02-23 10:27:54 +0200


You can Freeze or Split the title area as explained in this FAQ and put the button in this area.


You can create a custom toolbar saved & available for the spreadsheet: ToolsCustomizeToolBars tab▸NewSave in (listbox): current spreadsheet.

Then you can add tools, commands & macros you want to the custom toolbar. See CustomToolBar.ods


edit flag offensive delete link more


Thank you, but is there another solution? What if I want put several buttons on a sheet and I can't make title area big enough to accommodate all these buttons.

shma_lo gravatar imageshma_lo ( 2016-02-17 05:10:11 +0200 )edit

It works! Thank you very much

shma_lo gravatar imageshma_lo ( 2016-02-25 19:32:33 +0200 )edit

Question Tools

1 follower


Asked: 2016-02-15 03:39:19 +0200

Seen: 70 times

Last updated: Feb 23 '16