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

[shma_lo]

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.

[PYS]

Hi

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

[EDIT]

You can create a custom toolbar saved & available for the spreadsheet: Tools▸Customize▸ToolBars tab▸New▸Save in (listbox): current spreadsheet.

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

Regards

[shma_lo]

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]

It works! Thank you very much