Macro to Hide Blank Rows

Hii,

Please find the attached sample file.

I'm trying to hide and protect my M & N columns coz i had my formulas on that columns,i dont want
any one to see or edit that and i need to hide my blank rows as well,i can't delete
A11:A15 rows because i need to add more employees further.I have a macro running with the
button but when i protect the sheet i cant run it.

Any Suggestions..

Thanks,
Ak

Hi akbar, here's an example that I hope you will find useful:

Please Login or Register  to view this content.

You can use set protection using UserInterface to allow macros to work, or alternatively by unprotecting the sheet every time you do the routine. In the example here, I toggle between hide and unhide both the empty rows and columns M & N.

Cheers,
berlan

Thanks for your reply berlan,

how could i assign that to my command button..

No problem, glad to help! Thanks for the positive rep

Implemented the code into your commandbuttons and put the protection code in an open_workbook routine in the ThisWorkbook module. See attached.

Best,
Johan

Thanks Berlan for your response,

But its hiding M:N columns too,i dont want that to happen only the rows to be hidden..

I have changed myself,Thanks a lot Johan..

Hi Johan,

When i copied it to my original template it gave me ,run time error - 1004,unable to set the hidden property of the range class..