Ask Your Question

Eaglecat's profile - activity

2018-11-29 04:51:40 +0200 received badge  Famous Question (source)
2018-08-02 17:03:44 +0200 received badge  Notable Question (source)
2018-06-23 16:44:29 +0200 received badge  Popular Question (source)
2018-06-23 14:50:58 +0200 received badge  Supporter (source)
2018-06-23 14:50:50 +0200 marked best answer Is there a simple way to pass a push button parameter to a macro?

I have a very elaborate Calc spreadsheet that has an index sheet with a lot of buttons that are used to navigate to various other sheets. There are about 70 other sheets and most of these have buttons for navigating back to the main index sheet and also go to other related sheets.

Currently I use separate macros to navigate to each of the sheets that exist in the spreadsheet and I call them individually with relevant command buttons that call to each specific target sheet macro. I would like to streamline this voluminous & mostly repetitive code and only use only one macro subroutine where the relevant target sheet name would be passed via an object parameter of the calling command button - but I don't know how to accomplish this.

Such a solution would also make it much easier to edit sheets by simply copying relevant command buttons from other sheets and modifying the relevant command button properties target parameter as required.

I have seen How to start a macro with user-specified parameters? but the answer in method 3 and example spreadsheet are both too obtuse for me to understand how to apply that to my case. Can you please elaborate for my specific case where I want to pass the name of a variable target sheet (preferably as a string variable but a unique integer index would be OK too).

2018-06-23 14:50:50 +0200 received badge  Scholar (source)
2018-06-23 14:37:15 +0200 answered a question Is there a simple way to pass a push button parameter to a macro?

Thanks Pierre for taking the time and effort to give such a detailed reply. I am fairly new to Calc. You have answered m

2018-06-23 12:23:07 +0200 received badge  Teacher (source)
2018-06-23 10:05:45 +0200 answered a question Open all documents in Read-Only mode by default

Set the file attibute permissions to readonly for all the documents you don't want changed - then no matter what applica

2018-06-23 09:47:48 +0200 answered a question Windows 10 automatically uninstalls LibreOffice - torrent file problem?

Obviously a Windows 10 problem. Have you considered using Linux? It's got a steep learning curve, but is much more secur

2018-06-23 09:32:38 +0200 asked a question Is there a simple way to pass a push button parameter to a macro?

Is there a simple way to pass a push button parameter to a macro? I have a very elaborate Calc spreadsheet that has an i