To excel experts: trying to expand excel

Question

1.00/5 (3 votes)

See more:

Hi All,
With Excel, we have 2 display modes, either a cell displays the Formulas, or it display the values.
The switch is in Options > Tab Display > Formula CheckBox.

Question: is it possible to have new displays like having the name of style of the cell, or Font name ?

I work with Excel 2003.

What I have tried:

I have macros that do the trick but result is in new WorkSheet and navigating in both WorkSheets in parallel is a pain.
Googled, but haven't found anything useful.

Posted 18-Apr-17 6:24am

Patrice T

Updated 18-Apr-17 10:38am

v2

Add a Solution

Comments

CHill60 18-Apr-17 14:13pm

You're going to have to write a wrapper around Excel. The answer is - "no" you can't extend Excel in this way as yet. You could always suggest it as an upgrade to Microsoft. I doubt it will happen anytime soon though

Patrice T 18-Apr-17 14:32pm

Thank you for the fast answer.
I was a little afraid of getting that kind of answers. :)

CHill60 18-Apr-17 14:35pm

Yeah - I was sort of sighing as I typed. I'm trying to think of a way to use a "hotkey" to some VBA that would give you what you need, but I'm fighting my system at the moment (don't ask :( )

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2017-04-18T10:18:00

Ok - the only way I can think of to achieve this ... especially as you have "macros that do the trick" ... potentially use a hotkey to run the macro that shows the info Assigning Macros to Short-Cut Keys in Excel[^]. Next problem from your statement is you say this is going into a new Worksheet ... so you *could* try arranging them side-by-side to display the info you want Display sheets side by side[^] - you'll sort of need an "undo" ... probably the same hotkey tbh.
Or... a pop-up with the info? How to: Create a Custom Dialog Box [Excel 2007 Developer Reference][^]
Or ... add annotation/comment to the cells with the extra info? Excel 2003/2004: Working with Comments, UWEC[^]

Good luck !

Maciej Los · Accepted Answer · 2017-04-18T10:38:00

In addition to solution 1 by CHill60[^], you have to create Excel add-in which is executed together with MS Excel. So, macro will be avaliable whenever Excel is opened. You can create menu item for your macro (even option and checkbox).

In case, you want more details, don't hesitate to ask.

Assuming that you know how to create new Excel add-in, and you want to get more details about creating new menu item, please see:
VBA Express : Excel - Add custom menu items to the Menu Bar[^]

To excel experts: trying to expand excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0