Search Cascade Support
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. 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.How to Enable Macros
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. //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.