How JustAnswer Works:

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

Ask comp_audio Your Own Question

comp_audio
comp_audio, Other
Category: Microsoft Office
Satisfied Customers: 164
Experience:  20+ years experience supporting most all Microsoft Office applications.
44312836
Type Your Microsoft Office Question Here...
comp_audio is online now
A new question is answered every 9 seconds

I have a MS Word document created as a form. Originally, I

Customer Question

I have a MS Word document created as a form. Originally, I created the form in Excel, but those I work with didn't like the restrictions - wanted Word features. So now I need to know how to do the following:

1. Within in form, I used the formula function to average a group of cells. I want to limit the values in the cells from 0 through 5.

2. Zero values I want to appear in red font and for all other values the font should be black.

Is there a VBA statement that can do all this?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  flopcat98 replied 1 year ago.

The best way to do that is to leave the table in excel then insert it into the word document it will be like a picture in a word document but you can click on it and retain all the functions of excel in that one spot.

 

to do that correctly in word go to

file / insert object / excel work sheet

 

then select the excel sheet and the part of it that you want to use.

Customer: replied 1 year ago.


Is embedding Excel in Word the only option? My concerns are: (1) Will Word retain the protect function so that a user cannot expand the worksheet column, etc.?, (2) In my Excel sheet, cells requiring data are empty and an average formula appears below each section (five sections on the form require tallying, the remainder of the form is a text document), (3) the Word doument is protected by sections of the document- how does it react with an Excel spreadsheet embedded?


 


What other questions should I ask that I don't know to ask????

Expert:  flopcat98 replied 1 year ago.
I honestly dont know. I am going to opt out and let somebody else work with you that may use this stuff all the time. I know how to do it and i know that is going to work a lot better for you than trying to get the word to do what excel can in its limitted table functionality.

You can put it into a frame and while they might be able to move the columns they couldnt move it to effect the rest of the word document.

You might want to use 2 sections of the spreadsheet. one where they can enter data and another where the formulas are and i believe that you could insert the second part as locked either in the excel or the word. Or i would just use the excels functions on locking down that part rather than the words.
Customer: replied 1 year ago.


What is my next step?

Expert:  flopcat98 replied 1 year ago.
i honestly cant give you step by step instructions. maybe somebody else here can. i have left it on opt out so they can jump in

but if i was doing it i would get the spreadsheet exactly how i wanted it and lock it down using whatever exel will give you to lock it down.

then insert it into the word document and see how well it works.
Customer: replied 1 year ago.

At this point, I should wait for another support technician to reply? I do appreciate your help, but due to the nature of the users, I have to be absolutely sure that the end product works without issue. Thank you and I'll wait until I hear from someone for the answers to my questions.

Expert:  comp_audio replied 1 year ago.
I would like to assist you with this. Please let me know a good time to catch you online here.
Thanks,
Matt
Customer: replied 1 year ago.


The best time is now, but I assume that most people aren't working at 5:50 a.m. (EST)! I'm just nuts. However, if you are awake at this hour, please send me a message.


 


Are you available anytime between 8:30 - 10:00 a.m. (EST) today, Nov. 6th? My job generally pulls me away from my desk, but I will get your e-mail message on my phone so as soon as I get it, I'll get to my desk and contact you soon after.

Expert:  comp_audio replied 1 year ago.
I should be on most all day. I will step away from my pc once in awhile, but msg me and I will be right with you.
Customer: replied 1 year ago.


I am at my desk now. I will keep the window open.

Expert:  comp_audio replied 1 year ago.
Hello, is there a way to you send me this word document so that I can take a look at it and see what we are working with?
Customer: replied 1 year ago.


How do you want to receive it? Do you want the original copy of the document rather than the test documents I performed the cut and past from Excel but it doesn't seem to work - especially for users with little Excel experience.

Expert:  comp_audio replied 1 year ago.
I would like both if that's okay, that way I can see what you had, and what your looking for in a way.email=matt@compaudio.net
Expert:  comp_audio replied 1 year ago.
I got a good look at the files and I believe I can assist you in getting the final results your looking for. Would you be okay giving me until tomorrow afternoon to give you a thorough answer and also send completed files to you?
Customer: replied 1 year ago.


There is no rush at the moment. Staff members are using the more difficult Excel file until I can finalize the Word document. Is this something you can help with by Friday of this week or do you need more time?

Expert:  comp_audio replied 1 year ago.
I will do my best to get you a usable solution before Friday. Thanks for your patience.
Expert:  comp_audio replied 1 year ago.
Hello, I have sent you the files I worked on for you. Please review this to see if this is an acceptable solution for you. Thanks and I look forward to hearing from you.
Expert:  comp_audio replied 1 year ago.
Hello, if you found my answers helpful please let me know by accepting my answer and giving me an excellent rating. If you still need more assistance please reply and let me know so that I can continue to work to solve your problem. Thank you very much for the opportunity to work with you.
comp_audio, Other
Category: Microsoft Office
Satisfied Customers: 164
Experience: 20+ years experience supporting most all Microsoft Office applications.
comp_audio and 6 other Microsoft Office Specialists are ready to help you

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 Customer New York
< Last | Next >
  • 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 Customer New 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!!!! Alex Los 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. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, 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. Esther Woodstock, 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. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions