Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I'm trying to record a macro in excel for mac 2011 and get…

I'm trying to record...

I'm trying to record a macro in excel for mac 2011 and get the error message "Unable to record". Developer tab is activated, and warning box on macros unchecked.

Technician's Assistant: If you open your Excel document and go to File -> Revert To, do you get the option to "Browse All Versions"?

There is no option for "Revert To"

Show More
Show Less
Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
Excel file I am working on is attached for reference.
Customer reply replied 1 month ago
I'm working in Excel for Mac 2011 v 14.4.4
Answered in 4 hours by:
3/14/2018
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,357
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

Did you try the same Excel file under Excel for Windows?

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
I don't have windows only mac

I opened the Excel file from both Windows and Mac and saw nothing in the Macros dialogue box. Are you sure it is a right file? Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
I am trying to create a macro and it says "unable to record" - so yes, there are no macros, because it is preventing me from creating them. That's the problem I'm trying to solve -

Okay, please let me know what do you want "record" and let me try it from my side. This will hep us determine what kind of issue it is, system specific, document specific, or even application specific. Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
I want to create a macro/button that clears the contents of a specific set of fields in the tab 1. Enter New Costs+Revenues, column D. All the ones that are in black bold font, and have a green dot in column B. Specifically:
D9-11; 13-14, 19-21, 27-38, 42-45, 49-50.

My Excel on Mac in under updating. I am going to first try it in Windows.

FYI - Excel files are compatible on both Windows and Mac.

Ask Your Own Microsoft Office Question

Okay, I think I no need to upload what I recorded I have know the reason and solution.

When you save the Excel with macro(s) recorded, you should change the file extension (file format) to Excel with Macro (xlsm), not the existing xlsx file. Otherwise your macro will be lost.

Please see my screenshot below for your information.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
OK, I saved as macro enabled, but still get the same error message "Unable to record"

Please check this video to see if you have missed something

https://www.youtube.com/watch?v=a2bTaFEhE0A

Sorry I can't test with Excel for Mac 2011 for now. I have to return home to test it on my Mac Pro which is running on 2011 with El Capitan.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
I looked at the video. I am doing NONE of those things because i can't take those steps. I can't take that first step - after I hit record, and name the macro, I get the error "unable to record" and that stops any further action. So the video was great for showing how to record, but I can't get to that step. I think maybe theres something missing from my version of excel - when I opened the visual basic editor, nothing shows up, just a blank screen. I've done macros before so I know it's possible...

Did you try any other Excel file? Try create an new blank Excel file then click the Record button. This will tell you if it is application issue or document specific issue.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
Tried another excel file, same thing happens, so it's application not file specific.

Okay, please be patient for my test at home later tonight (AEST). Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
OK

My apology for the delay. Just got a chance to access my home computer with Excel for Mac 2011 installed. I haven't been using the desktop for a long while.

You file has no issue to record and replay macros. Please see below the screenshot for your kind reference.

I am also attaching the Excel workbook with macro saved. It is in ZIP format due to the site's limit.

Sorry again for replying late. Please kindly review the rating and let me know if anything else that I can be of assistance. Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 1 month ago
I was able to try this and appreciate you sticking with it. I can now record macros, so progress. But, when I try to run the one you recorded (which isn't the macro I'm trying to record FYI - I'm trying to get values to go to 0 for a selection of cells in column 10. See my entry above on March 14 at 5:20 for specifics.)When I run the macro you created, it says "Compile error, can't find project or library". Image attached. So, still unsolved.

As per your description, I believe the issue is with your Office 2011 for Mac. I would suggest you simply remove Office 2011 and reinstall it again.

Please test and review your rating for my service. Thanks.

Ask Your Own Microsoft Office Question

Any update please? Thanks.

bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,357
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified
bbao and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 1 month ago
i have find, download, etc to do the reinstall, it will take a while as I have other priorities today. Will try to do it by tomorrow EOD pacific time and let you know.
Customer reply replied 1 month ago
I downloaded and reinstalled and it works! Thanks.

Great!

Ask Your Own Microsoft Office Question
Was this answer helpful?
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,357
1,357 Satisfied Customers
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP

bbao is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
Need help assigning background colors of plot area to data
Need help assigning background colors of plot area to data source … read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I need to reinstall Microsoft office. I have my serial key.
I need to reinstall Microsoft office. I have my serial key. What do I do … read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
In an excell spreadsheet, I hid column A and now I cannot
In an excell spreadsheet, I hid column A and now I cannot get it to show … read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
788 satisfied customers
Just installed Microsoft Office on my new iMac. Where is it?
Just installed Microsoft Office on my new iMac. Where is it? … read more
Don Williams
Don Williams
BS
14 satisfied customers
There was an upgrade on my MacBook Air Laptop this
Hello! There was an upgrade on my MacBook Air Laptop this afternoon. I have been able to work with everything except with Microsoft Word; the response is always "Microsoft Word is Currently being upda… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
My normal.dotm is corrupted. Word 2010. 2 days ago.
my normal.dotm is corrupted JA: What application are you using? Customer: word 2010 JA: When did you last update Word? Customer: 2 days ago JA: What have you tried so far with your Word? Customer: eve… read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
I have a word created document that I am not able to open.
I have a word created document that I am not able to open. It does not give me the choise of word a … read more
Moses C
Moses C
Bsc
566 satisfied customers
MY outlook fails to connect to the server. To resolve this
Hi, MY outlook fails to connect to the server. To resolve this we have reinstalled outlook a few times. Which resolves the issue but then a few days later the same problem comes back. I have also rein… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I have a surface 4 and it came with 365 home and student,
i have a surface 4 and it came with 365 home and student, word would not open anymore. I tried to reload it but I could not find the activation code. i do have a microsoft account. but now word has co… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I BOUGHT A NEW COMPUTER AND HAVE BEEN UNABLE TO SYNCRONIZE
i BOUGHT A NEW COMPUTER AND HAVE BEEN UNABLE TO SYNCRONIZE OUTLOOK WITH ICLOUD CAN YOU HELP? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
956 satisfied customers
I received a new charger less than 6 months ago...now I am
I received a new charger less than 6 months ago...now I am in Spain and my charger isn't working...I only have 20 minutes left....I need an international number to access help... … read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I'm working in Microsoft Project. When I schedule tasks
I'm working in Microsoft Project. When I schedule tasks manually with a 1-day duration, the task starts and ends on the same day. When I auto-schedule tasks with a 1-day duration, the task starts on o… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I thought I was all done, No spreadsheets after paying and
No spreadsheets after paying and only got one mouth … read more
Mike Taylor
Mike Taylor
42 satisfied customers
Are you there? Word. I don't remember ... but that's not the
can i tell you the problem...before you ask me questions ?? please … read more
Jason Jones
Jason Jones
AAS Information Technology
6,322 satisfied customers
I simply would like to download Microsoft office onto my new
I simply would like to download Microsoft office onto my new computer and I'm unable to because it keeps asking for a password ***** I do not have and it promises to send me a code via email and nothi… read more
Wes
Wes
Consultant
Bachelor\u0027s Degree
368 satisfied customers
I bought 365 about two months ago. I don't have a product
I bought 365 about two months ago. I don't have a product key. My computer crashed a few days ago and I'm desperate to get 365 back as MY Excel has critical docs that I can't access. … read more
Cody
Cody
Computer Science
2,156 satisfied customers
My normal.dotm is corrupted. Word 2010. 2 days ago.
my normal.dotm is corrupted JA: What application are you using? Customer: word 2010 JA: When did you last update Word? Customer: 2 days ago JA: What have you tried so far with your Word? Customer: eve… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
I'm using MacbookAir and a Microsoft Word file I want to
I'm using MacbookAir and a Microsoft Word file I want to work on has somehow become in need of repairing. Can you help? I've tried recovering the file but none of the tables are intact and it looks to… read more
bbao
bbao
IT Consultant
1,357 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x