Hi,
I've installed recently excel 2013 and when learning it I've opened the telemetryDashboard file "C:\Program Files\Microsoft Office 15\root\office15\1036\TelemetryDashboard.xltx".
In this file, it's possible to click on a cell and it will :
a) display rows which were hidden
and
b) change the color of an image.
This looks to be done without any macros and using hyperlinks with defined named.
I don't understand how this works and therefore to do the same in new excel sheet.
If someone could explain how it works ? File is attached but I have as well put above the link where this file is stored when excel is installed.
Thanks
I've installed recently excel 2013 and when learning it I've opened the telemetryDashboard file "C:\Program Files\Microsoft Office 15\root\office15\1036\TelemetryDashboard.xltx".
In this file, it's possible to click on a cell and it will :
a) display rows which were hidden
and
b) change the color of an image.
This looks to be done without any macros and using hyperlinks with defined named.
I don't understand how this works and therefore to do the same in new excel sheet.
If someone could explain how it works ? File is attached but I have as well put above the link where this file is stored when excel is installed.
Thanks