01-11-2017, 07:52 AM #1
Excel Mac 2016 stop macro warning on specific sheet.
- Member Since
- Jul 15, 2014
- West Sussex, UK.
- iMac 21.5" 3.1GHz Core i7 16GB RAM Sierra. iPad Air. iPhone 5S. iPod nano.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By fak119 in forum OS X - Operating SystemReplies: 8Last Post: 06-19-2016, 09:45 PM
By sgs1965 in forum OS X - Apps and GamesReplies: 0Last Post: 03-08-2016, 01:22 PM
By JohnBebb in forum OS X - Apps and GamesReplies: 0Last Post: 09-25-2015, 05:08 AM
By mrj002 in forum OS X - Apps and GamesReplies: 4Last Post: 09-14-2015, 01:16 PM
By sconnor707 in forum OS X - Apps and GamesReplies: 0Last Post: 09-15-2009, 01:52 PM