Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

A button in your spreadsheet that runs a macro

If you're used to Excel, you'll know the big button on the worksheet: "Create invoice", "Sort list", "Move to archive". Your colleagues don't need to know anything about macros; they just click. In Euro-Office you make a button like this from a shape. You assign a macro to the shape, and clicking the shape runs it.

We'll make a button for the macro Naar archief from Een rij automatisch naar een archiefblad verplaatsen als de status Klaar is, in the order list of Bloemisterij Het Zonnetje.

Step 1: the macro

First create the macro and save it, as described in Een rij automatisch naar een archiefblad verplaatsen als de status Klaar is. A button can only run a macro that is already in the file.

Step 2: draw a shape

  1. On the Insert tab, click Shape (1).
  2. Choose a shape that looks like a button, for example the rounded rectangle under Rectangles (2).
  3. Drag with your mouse to draw a rectangle next to your table, so it doesn't cover the data.
  4. Type the button text straight away, for example Naar archief. Press Esc when you're done.
Insert, Shape
Click Shape (1) and choose the rounded rectangle under Rectangles (2)

Tip: give the button its own colour under Fill in the panel on the right, so your colleagues can see straight away that it's a button and not a comment.

Step 3: assign the macro

  1. Right-click the border of the shape. If you click in the text, you'll get the text menu; in that case, click the border.
  2. Choose Assign Macro (1).
  3. In the Assign Macro window, under Macro name, choose the macro Naar archief and click OK.
Right-clicking the shape
Right-click the shape and choose Assign Macro (1)
The Assign Macro window
The Assign Macro window with the macro Naar archief

Step 4: click

Click anywhere in a cell so the shape is no longer selected. Then click the button once: the macro runs. In our example, the completed orders disappear from the worksheet and are moved to Archief.

The Naar archief button
The Naar archief button (1) next to the order list
After clicking the button
After clicking the button, only the open orders and the orders in progress remain on the worksheet

Changing the button later

A normal click runs the macro. If you want to change the text, colour or position of the button, right-click its border: the shape is selected without running the macro. You can then drag it or edit the text. Use Assign Macro to assign a different macro.

Pitfalls

  • The macro doesn't know where the button is. It works on fixed cells or on the selected cell, not on "the row next to the button". So one button per row makes no sense; create one button for the whole worksheet.
  • The macro works on the worksheet that is open. So place the button on the worksheet the macro is meant for.
  • Macros disabled? If a colleague has turned macros off, the button does nothing for that colleague. See Using macros safely: macros settings, autostart for colleagues and reuse.
  • In Excel, the button is an ordinary shape without an action. Excel can't run a JavaScript macro from it.

What isn't possible

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…