- Joined
- Jul 15, 2014
- Messages
- 759
- Reaction score
- 142
- Points
- 43
- Location
- West Sussex, UK.
- Your Mac's Specs
- 2021 iMac 24" M1 512/16/8/8 Sonoma. 2013 iMac 20.5" 3.1 i7 16GB Catalina. iPhone 13
I have set up a simple excel spreadsheet, which contains a macro button to sort the final column into low to high values.
Every time I open the file I get the macro warning inviting me to enable macros if I want to proceed. In the Windows version of Excel I also had the option to always allow macros on that specific file but I cannot find anyway to do that in the Mac version. It appears to be either enable all macros or none at all or am I missing something.
Failing that is there a way to sort a column of numbers into low to high without using a macro? I know I could use the sort tool but the spreadsheet is designed for a number of none-Excel users and the built in macro button is much better.
Every time I open the file I get the macro warning inviting me to enable macros if I want to proceed. In the Windows version of Excel I also had the option to always allow macros on that specific file but I cannot find anyway to do that in the Mac version. It appears to be either enable all macros or none at all or am I missing something.
Failing that is there a way to sort a column of numbers into low to high without using a macro? I know I could use the sort tool but the spreadsheet is designed for a number of none-Excel users and the built in macro button is much better.