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

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.


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


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.

It works! Thank you very much