SOLVED

In-cell button (show/hide rows)

%3CLINGO-SUB%20id%3D%22lingo-sub-2559745%22%20slang%3D%22en-US%22%3EIn-cell%20button%20(show%2Fhide%20rows)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559745%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20like%20to%20know%20how%20can%20I%20achieve%20an%20in-cell%20button%20in%20which%20are%20capable%20of%20hiding%2Fshowing%20rows.%20I%20achieve%20it%20using%20toggle%20button.%20However%2C%20I%20wanted%20it%20to%20be%20an%20in-cell%20button.%20Attached%20were%20the%20sample%20file.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2559745%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2559814%22%20slang%3D%22en-US%22%3ERe%3A%20In-cell%20button%20(show%2Fhide%20rows)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098170%22%20target%3D%22_blank%22%3E%40rbalza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi everyone, 

 

Would like to know how can I achieve an in-cell button in which are capable of hiding/showing rows. I achieve it using toggle button. However, I wanted it to be an in-cell button. Attached were the sample file. Thanks in advance.

1 Reply
best response confirmed by rbalza (Contributor)
Solution

@rbalza 

See the attached version.