Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel Mac 2016 stop macro warning on specific sheet.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="pine man" data-source="post: 1744371" data-attributes="member: 329282"><p>I have set up a simple excel spreadsheet, which contains a macro button to sort the final column into low to high values.</p><p></p><p>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 <u>all</u> macros or none at all or am I missing something. </p><p></p><p>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.</p></blockquote><p></p>
[QUOTE="pine man, post: 1744371, member: 329282"] 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 [U]all[/U] 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. [/QUOTE]
Verification
Name this item. 🍎
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel Mac 2016 stop macro warning on specific sheet.
Top