Kalpesh Agrawal- Kalpesh Agrawal
VBA Hide and Unhide the Columns and Rows
If you want to prevent confidential data inserted into your Excel sheet, you can hide the rows and columns.
I have been inserted some sample data in excel as below.
The code for Hiding and Unhide the Column and Row is as below.
Related: How to add VBA to the Excel and common terms of VBARelated: VBA Insert the Rows and ColumnsRelated: VBA Merge- Unmerge CellsWritten by: Kalpesh Agrawal (Actuarial Intern - IIB)