hide ,unhide columns on protected worksheet

[kamlesh]

hide or unhide rows and columns on protected worksheet,workbook using option
button or commnad button

 

[Dave Peterson]

Add a couple of lines to your routines.

'At the top
activesheet.unprotect password:="hi"

'do the work

'at the bottom
activesheet.protect password:="hi"