How to enable macros in Numbers

Search Cascade Support

Table of Contents Show

Search Cascade Support
How to Enable Macros
Cannot Run the Macro – Error Message
Security Risk Error Message
Check the Macro Settings
Can you do macros in Apple Numbers?
How do I enable macros?
Do macros work on Mac?
How do I record a macro in Numbers?

You need to Enable Macros for Cascade to run properly. Many of the features and buttons use automation in the form of macros. Without the macros, the screens will not populate properly or update.

How to Enable Macros

When opening Cascade on a Mac, a message box appears saying the workbook contains macros. Click on Enable Macros and you can start using Cascade.

In Windows, you may see a yellow bar at the top with a security warning.

Click on the button to Enable Content, allowing macros to run. You should only need to do this the first time you open Cascade. If you rename or move the file, it may ask you again.

Alternatively in Windows, you may see a pop-up box with a Microsoft Excel Security Notice.

Click on the Enable Macros button.

Cannot Run the Macro – Error Message

When opening Cascade for the first time, you may receive a message
‘Cannot run the macro [macro name]. The macro may not be available in this workbook or all macros may be disabled.’

Windows may be blocking the Cascade file preventing the macros to run. Follow these steps to unblock the file.

Close your Cascade file.
Open Windows Explorer and browse to the folder containing your Cascade file.
Right click on the Cascade file and select Properties.
In the Security section, tick the box to unblock the file.
Click on Apply then try opening Cascade again.

Security Risk Error Message

After receiving Cascade in an email, you may see a warning from Microsoft.
Security Risk Microsoft has blocked macros from running because the source of this file is untrusted.

To fix this, save the Cascade file to a folder on your computer – preferably in your Documents area. Then follow the procedure above to unblock the file.

Check the Macro Settings

In Windows, you may need to adjust the Trust Center settings if none of the messages appear. These instructions apply to Office 2019, 2016, 2013, 2010 and Office 365.

Open the Trust Center with File, Options and Trust Center.
Click on Trust Center Settings.
Click on Macro Settings.
Under Macro Settings, select Disable all macros with notification.
Click OK to close the settings.

You may need to close Excel, then reopen it, for the settings to take effect.

Further information is available at Microsoft Support.

I have an old video on that, but it is much the same today. You use Automator. https://macmost.com/using-automator-to-playback-actions.html.

Keep in mind that Automator records all Mac actions, whereas an Excel macro is just for Excel. So they ate very different things.

If there is something specific you are trying to accomplish in Numbers, ask about that. You may not need to record actions at all to do it.

Can you do macros in Apple Numbers?

Macros don't work in Numbers so is there a way to write a script in/for Numbers to do what macros do in Excel (Basic language)?

How do I enable macros?

Change macro settings in the Trust Center.

Click the File tab..

Click Options..

Click Trust Center, and then click Trust Center Settings..

In the Trust Center, click Macro Settings..

Make the selections that you want, then click OK..

Do macros work on Mac?

Will Excel Macros Work On Mac? If you have Excel downloaded onto your Mac, macros will definitely work. However, macros don't work on Apple's version of Excel, called Numbers, so if you try using them there, you'll like get an error message.

How do I record a macro in Numbers?

Follow these steps to record a macro..

On the Developer tab, in the Code group, click Record Macro. ... .

In the Macro name box, enter a name for the macro. ... .

To assign a keyboard shortcut to run the macro, in the Shortcut key box, type any letter (both uppercase or lowercase will work) that you want to use..