hello everyone,
i need a button that hides and unhides rows based on cell value of the column (No. Date) if the date is more than 6 days ago it becomes hidden, and whats left is the recent ones which are this week. but i can hide and unhide it whenever i want that’s important
it’s important...
In my previous company, we had a full-time Excel Guru who would do crazy coding to simplify our analysis job and she created an analysis sheet which had prepopulated items which may or may not be useful for a particular project. The ones which are NOT useful will remain zero, and can be hidden...
Hi all,
IO have a workbook with many sheets, only some of which the end user interacts with. I have created a Landing Page which has buttons that a pushed to reveal the appropriate sheets based on the action the person wants to take with the workbook. In the case that someone selects the wrong...
Hello,
I am trying to fix a macro that hides the listed "deliverables" on my WS. With lower number of deliverables, the macro executes quite quickly, but once there are 10 or more deliverables the macro takes a very very long time. Is there a way to simply or fix the following macro to make it...
Could someone please respond to an ignorant Excel User with steps to:
1) Install a button
2) The macro behind the button needs to hide columns D, F, H, J
3) The same botton if pushed again unhides D, F, H, J
Please respond with step by step, I am not a smarty.
Thanks so much
Hello ALL,
I have searched all over the various threads but I did not find anything that resembles my issue.
I have created a Workbook that uses a macro to create additional worksheets. The macro is activated by a button. What I would like to do is make sure that the user will not be able to...
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.