+ Reply to Thread
Results 1 to 6 of 6

How to stop a macros in mac excel 2011

  1. #1
    Registered User
    Join Date
    11-05-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    33

    How to stop a macros in mac excel 2011

    Hi,

    This has been driving me crazy for an hour. I want to add another command button into my spreadsheet but it won't let me select it from the toolbar. It is currently disabled.

    I currently have a command button already where I can click on it and it performs a macro by inserting a new row. Now I have gone onto the editor and clicked on the stop button but I still can't select a new command button from the toolbar and if I click on the current command button, it still adds a new row.

    My question is on a mac excel how can I completely stop a macros running so that I can add more command buttons?

    Also when creating a macros, is it best to imply it on the worksheet or to record it. These buttons will add and delete rows.

    Thanks

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How to stop a macros in mac excel 2011

    I don't know the MAC keyboard but on microsoft keyboard it's Cntl-Break/Pause....HTH
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    11-05-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: How to stop a macros in mac excel 2011

    Quote Originally Posted by judgeh59 View Post
    I don't know the MAC keyboard but on microsoft keyboard it's Cntl-Break/Pause....HTH
    Hi, I tried clicking on Stop button and pause button on Macros, but it still won't let me select a new command button from the toolbar. I can't even right click on the current command button to delete it, it just clicks the button which I don't want
    Last edited by carlbrooks; 11-06-2013 at 01:20 PM.

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How to stop a macros in mac excel 2011

    actually I'm not talking about the toolbar buttons, I'm talking about keyboard commands, but again, I don't know MAC keyboards.....I just looked this up, this should force a quit, but I'm not sure that's what you want....CMD-OPT-ESC keystrokes.....

  5. #5
    Registered User
    Join Date
    11-05-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: How to stop a macros in mac excel 2011

    Quote Originally Posted by judgeh59 View Post
    actually I'm not talking about the toolbar buttons, I'm talking about keyboard commands, but again, I don't know MAC keyboards.....I just looked this up, this should force a quit, but I'm not sure that's what you want....CMD-OPT-ESC keystrokes.....
    Hi figured it out, it was because the worksheet was locked at the bottom. It would have been nice if it told me sheet was locked but it never did.

    Thanks anyway

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How to stop a macros in mac excel 2011

    No problem.....glad you could figure it out....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. List of macros (Excel 2011 for Mac) and- if it exists - their translation in french
    By PhilippeS in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 10-17-2012, 05:57 AM
  2. [SOLVED] Converting Existing formulas into Macros in Excel 2011
    By Jhertilus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2012, 11:35 PM
  3. Replies: 1
    Last Post: 05-16-2012, 09:57 PM
  4. Help with Date Macros - eg. Change Values From Jun 5, 2011 to 05/06/2011
    By Red2Black in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2011, 08:44 AM
  5. Excel 2011 Macros for Mac
    By dwhitey1124 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2011, 12:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1