Excel Ctrl Tilde To Show Named Range

Is there a way upon pressing ctrl+~ that instead of displaying the formula in each cell, display that cells respective name. So if there is no name for that cell, and name is defined as named range, the cell would just be blank.

thanks in advance!

thanks for the quick response!

anything thoughts on how to best "simulate" this event/action. basically, regardless of hotkey or button, for a given sheet - how would you be able to toggle between a state where named ranges where in cells and then return back...like answer mode.

thanks!

Given that named ranges can be more than one cell, here's a routine which toggles overlaying the named ranges on the active sheet with shapes.


Put code in standard module and assign shortcut.

Please Login or Register  to view this content.

thanks for the reply.

I receive Error 1004 "Application-defined or Object-defined error" on line "If nm.RefersToRange.Parent.name = ActiveSheet.name Then"

Do you have any names with invalid references?
I.E. if you go into Name Manager, anything with #REF or similar?

Modified to test the validity

Please Login or Register  to view this content.

Welcome

Thanks for the help!

worked perfectly.