-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
[VBA] - Hide Column in All Worksheet and Sum of a Column in all worksheet
- Thread starter rsolanki
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,382
- Office Version
- 365
- Platform
- Windows
You can get the code to hide a column or sum a column simply by turning on your Macro Recorder, and record yourself performing those steps manually on one of your sheets.
Then stop your Macro Recorder, and you will have the VBA to do that on one sheet. Then, simply drop that code in a VBA loop that looks through all sheets.
Here is a link to a past post that shows you how to loop through all the sheets in your workbook: VBA Loop through All Sheets Except Sheet1
Give it a shot, and see how far you get. If you need help, post back to this ticket with the code you put together, and we can help you make any necessary adjustments to it.
Then stop your Macro Recorder, and you will have the VBA to do that on one sheet. Then, simply drop that code in a VBA loop that looks through all sheets.
Here is a link to a past post that shows you how to loop through all the sheets in your workbook: VBA Loop through All Sheets Except Sheet1
Give it a shot, and see how far you get. If you need help, post back to this ticket with the code you put together, and we can help you make any necessary adjustments to it.
Upvote
0
