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 4 months ago
Excel file I am working on is attached for reference.
Customer reply replied 4 months 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,821
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 4 months 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 4 months 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 4 months 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 4 months 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 4 months 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 4 months 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 4 months 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 4 months 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,821
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 4 months 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 4 months ago
I downloaded and reinstalled and it works! Thanks.

Great!

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,821
1,821 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

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I saved over a Microsoft Word document on my Mac. Is there a
I saved over a Microsoft Word document on my Mac. Is there a way I can revert to the previous document? … read more
bbao
bbao
IT Consultant
1,821 satisfied customers
Will a spreadsheet macro program developed in 2005 operate
will a spreadsheet macro program developed in 2005 operate in excel 2017 … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I would like to create a "date stamp" relative to the "Yes"
I would like to create a "date stamp" relative to the "Yes" form control radio button in a group of three total radio buttons: "N/A", "Yes" , "No"When the user selects "Yes" I want the corresponding f… read more
bbao
bbao
IT Consultant
1,821 satisfied customers
Have a problem with a text box in an MS Word 2010 doc. When
Have a problem with a text box in an MS Word 2010 doc. When I click on the text box, Drawing Tools opens...I can't get rid of it. I have numerous text boxes that function right, this only happens on 2… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,463 satisfied customers
I have a relatively unsophisticated knowledge of using VBA
I have a relatively unsophisticated knowledge of using VBA macros in Outlook 2016. I copied a macro off the internet and followed various instructions for adding the macro to Outlook, adding a macro b… read more
bbao
bbao
IT Consultant
1,821 satisfied customers
I also have another question related to some macro code you
I also have another question related to some macro code you wrote for me to produce a top ten list from a set of data - the code you wrote works perfectly on all PC computers but one of my schools wor… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Hello, Id like to create a Macro in Outlook 2010 as follows: Open
Hello, I'd like to create a Macro in Outlook 2010 as follows: Open encrypted email message Go to Actions --> Edit Message Click on File --> properties Check off the encrypted option Save a close… read more
fbeltramini
fbeltramini
23 satisfied customers
Hi,Im using Excel for Mac 2011 Version 14.3.8I am able
Hi, I'm using Excel for Mac 2011 Version 14.3.8 I am able to record a macro, but it won't work when i try to run it. I followed the tutorial with the basic fill month example. I can record, name the m… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,130 satisfied customers
How do I access macros in an add-in ??Firstly, I am not a
How do I access macros in an add-in ?? Firstly, I am not a programmer... just a 'winger'.. I have built several macros for the Excel 2010 PC version. Placed them in an ADD-IN for ease of distribution,… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,463 satisfied customers
Every time I try to open an excel file (which has visual basic
Every time I try to open an excel file (which has visual basic macro in it) on my mac 10.8.4 I receive the message - This file contains Visual Basic macros. The macros have been disabled, .... If you … read more
John T. F.
John T. F.
Self-employed Business Owner
Two Decades Field Experience
1,041 satisfied customers
Running Microsoft Excell. Running old macro. When I email macro
Running Microsoft Excell. Running old macro. When I email macro to windows 8 user and try to run the macro I get a runtime error 1004.… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,463 satisfied customers
I have several files (.docx) based on a Word template that
I have several files (.docx) based on a Word template that holds data in Content Controls. I want to programmatically extract the contents from those controls into a single file, say Excel where a row… read more
Brandon M.
Brandon M.
System Administrator
Vocational, Technical or Trade Scho
2,143 satisfied customers
I am experienced using Excel. I have a spreadsheet that needs
I am experienced using Excel. I have a spreadsheet that needs to be sorted. I sorted it a few days ago, it worked just fine, today it will not sort. I am using Version 14.3.0 and my Mac is on OS X ver… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Excel question:How can I use Custom validation to prevent
Excel question: How can I use Custom validation to prevent user from entering data into cells based on contents in other cells. Example: Area LF Pieces 2000 If area has data entered in that cell, then… read more
John D
John D
Bachelor Degree in Engineering
400 satisfied customers
Just installed office 2011 on a new mac mini. Macros will
Just installed office 2011 on a new mac mini. Macros will not work. 'Object not registered' and 'some content un-readable' are the messages, although they work fine on all the other machines we have. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,463 satisfied customers
I have a spreadsheet containing a hyperlinked email. Users
I have a spreadsheet containing a hyperlinked email. Users are encouraged to complete the spreadheet and forward it to the emailed recipient. Is it possible to ensure the spreadsheet is attached. (Man… read more
Brandon M.
Brandon M.
System Administrator
Vocational, Technical or Trade Scho
2,143 satisfied customers
Ctrl C and ctrl v have been acting very strangely in my Excel
Ctrl C and ctrl v have been acting very strangely in my Excel 2003 SP3. Ctrl c will delete rows. I am creating macros. I also installed the easyfilter add-in. Please help! I am desperate. I have a use… read more
Nick H.
Nick H.
Desktop Support Engineer
Bachelor\u0027s Degree
978 satisfied customers
Why wont my Macro Record button work and why is "Create Mac
Why won't my Macro Record button work and why is "Create Macro" greyed out on the drop down menu. I can write VBA code, but it won't record. Is it some security box checked somewhere? I'm on Office 20… read more
John D
John D
Bachelor Degree in Engineering
400 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