Benches Uncategorized

5

Does Numbers allow creation of macros?

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I have been using Panorama until now but thinking of switching. A nice feature of Panorama is the ability to record/use a macro. Does N. have a similar function?

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Short answer : NO !

    Yvan KOENIG (VALLAURIS, France) vendredi 19 mars 2010 19:16:33

  2. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    No macros but if you feel like learning Applescript you can automate it a bit. You can also use Automator's "record" workflow (or whatever it's called), save your "macro" as a service, and make a keyboard shortcut for it.

  3. 0

    Richard Pitcairn

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    A very excellent idea. I had forgotten about Automator.

  4. 0

    thackbarth

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I'm curious to hear if this has worked for you. I would like to use Automator to create a "macro" for Numbers as well, but haven't been able to make it work. I want to be able to repeat the same editing/formatting tasks on every Numbers sheet I create.

    I export my data to Numbers (no fancy formulas, just text within the cells). I want to automate the process of deleting the same rows and columns on every sheet, changing the font size, changing the margins, and a series of 'find and replace' edits.

    Is this possible using Automator? This was a a really easy task for Excel with the Macro tool. I've tried using Automator, but get errors whenever I try to run recorded actions.

    Thanks for your help!

  5. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    One more question using the Excel vocabulary 😟

    May you take care to use the Numbers one ?

    *In Numbers, a sheet may contain table(s), text block(s), media item(s) or nothing

    but _it will never contain cells_* !

    May be done with AppleScript.

    Send me a Numbers document with the original table

    and the edited one.

    Click my blue name to get my address.

    But, I'm wondering why you must do that.

    Why not use a custom template with most of the attributes already defined.

    Custom templates where defned to fit these needs.

    Yvan KOENIG (VALLAURIS, France) mercredi 28 avril 2010 16:16:25