Does anyone know if it is possible *and* how to create a link in Excel that would hide or unhide (depending on if the range is currently hidden or unhidden) a range of rows?
Hi
I think from what you are saying you want to look at a macro . Go to Tools>Macro>Record new macro and either name it when prompted or settle for Macro 1(the default), now perform your actions i.e unhide your rows. Then click stop recording. You will now have a macro which you can attach to a Form button which will unhide your rows when clicked . You can do the same thing to produce a macro to rehide these rows
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
