Can Excel unhide/hide rows just by hovering a mouse over it

[atuljadhavnetafim]

Hi,

I have values in D4 Cell which is sum of D5:D8 and again I have value in D9 cell which is sum of D10:D13 and so on......
now I don't want to use Group/Ungroup function because there are so many items in my excel and not practice to group/ungroup each time.
so what I want, whenever I hovering mouse to D4, excel slowly unhide Row 5 to 8 and once I remove mouse from D4 excel slowly hide those row.

I know this is possible in excel but just know howwwwww.

Thanks in advance

 

[Legacy 456155]

If you are going to use timers, you might want to look at a UDF called from a HYPERLINK function. That way the timer is only started when you mouse over the cell with the HYPERLINK function (the UDF can take care of unhiding the rows) and the timer proc can cancel the timer once the cursor is elsewhere.

Rory, How do you call a UDF from a hyperlink function?

 

[RoryA]

Just pass it as the first argument of the HYPERLINK function. It eliminates many of the restrictions on UDFs and it will be triggered by hovering over the link.

 

[Legacy 456155]

Just pass it as the first argument of the HYPERLINK function. It eliminates many of the restrictions on UDFs and it will be triggered by hovering over the link.

I'm not understanding. I tried it and could not get it to work. Would you mind posting a simple example. Should I start a new thread?

 

[mark hansen]

If you start a new thread on the UDF hyperlink thing, please let us know, this is very educational.

 

[Legacy 456155]

Brand spankin' new thread here.

 

[RoryA]

Have a look at Chandoo’s article here: Interactive Dashboard in Excel using Hyperlinks » Chandoo.org - Learn Excel, Power BI & Charting Online

Let me know if still stuck and I’ll try and post something when I have a chance.

 

[Legacy 456155]

Thanks Rory. I just created a new thread. I'll throw your link in there.

 

[atuljadhavnetafim]

Dear dataluver,

the last version is exactly what I want, this is really amazing and will create impact on my dashboard.
it is really impressive and thanks for giving a solution.

I will copy these codes and paste in my dashboard file and hope it will work fine.

Many Thanks

 

[atuljadhavnetafim]

Hi

i am getting belwo error while running this code in my file.
i have just copy paste codes in modue and paste in my file
also copy codes from your sheet and paste in RA Bill Summary sheet code. i have also change cell reference according to my file.
but nothing happening, while running macro manually then below error show.
can you please help,

 

[Legacy 456155]

Atul, you probably need to set a reference to Microsoft Scripting Runtime.
From your VBA IDE, select Tools -> References -> Microsoft Scripting Runtime.
If that does not work, try the example file I posted in post #8.