Getting Closer...

A few more folks have commented (unanimously positively) on the idea of creating a video-based course on how to create macros. I really am humbled and enthused by the positive feedback, and I appreciate it. Again, you can see all the feedback at my blog, located here.

I'm getting close to announcing something about the course. I'm leaning toward doing a "limited enrollment" course, at least the first time around, so that I can work more directly with those in the course to make it as good as possible.

Anyway, I may be ready to announce something about this in as little as a week. You'll want to keep your eyes peeled, as the the announcement will be in this very space.

Thanks, again, for the feedback.


ExcelTips (ribbon) for 25 July 2015

Strange Message about Others Making Changes in a Workbook

Have you ever tried to save a workbook, only to be notified that someone else has made changes in it? What if you are the only one with access to the workbook? This tip examines this scenario and presents some ideas on why it may be happening.

Read this tip »

(Thanks to Guy Goodwin, Erik Oberg, Scott Renz, and Piers Morgan-Harvey for contributing to this tip.)

Macros extend Excel
Removing All Macros

Macros are stored as part of a workbook so that they are always available when you have the workbook open. If you want to get rid of the macros in a workbook, there are a couple of ways you can do it. This tip examines two quick ways to get rid of the macros.

Read this tip »

Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

Charts and charting
Reading Values from Graphs

Adding a trendline to a graph will allow you to see trends a bit easier, depending on your data. You can even utilize an option that allows you to see what formula Excel uses to create the trendline from your graph's values.

Read this tip »

Cell formatting
Referencing External Cell Colors

If you want to reference cell colors external to your current workbook, there is no way to do it using Excel functions. You can, however, create your own macro that will do the referencing for you.

Read this tip »


Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Changing the Ribbon's Size and Look

I am a member of a club that teaches computer skills to senior citizens. We have a new student who is sight impaired. Despite copious amount of searching I have been unable to discover any means of changing the look and feel of the ribbon to make it easier for the student to use. Is there a way to modify the ribbon's size and look?
—Brian Mackie (provide an answer for this Help Wanted question)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035