hide rows or columns

vra

Board Regular
Joined
Apr 16, 2011
Messages
95
Office Version
  1. 2019
Platform
  1. Windows
  2. MacOS
After filling figures in a table how to hide a row/ column having 0 in a paricular column having a particular heading .. what command or program so that in every worksheet or file it can be used , to avoid it doing manually.Kindly suggest ?
 
I am unable to use the sheet if i move it to other excel files/workbook. I have hundreds of excel files in which I have to move these excel sheet & then make use of these code & buttons created. but in every file i have to copy code , assign macro to buttons. Its lengthy procedure. Why the macros dnt get copied to buttons
 
Upvote 0

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
kindly reply
macros do not get copied with the sheet when i move the sheet to other workbooks
What can we do ?
 
Upvote 0
Hi,

I'm sorry I do not have a solution to that problem. The best thing you can do is start a new thread explaining what your new situation is and what you require to solve the problem.

Good luck
 
Upvote 0

Forum statistics

Threads
1,224,598
Messages
6,179,818
Members
452,946
Latest member
JoseDavid

We've detected that you are using an adblocker.

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.
Go back
Back
Top