hide ,unhide columns on protected worksheet
 

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

hide ,unhide columns on protected worksheet
 

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"



kamlesh wrote:

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

--

Dave Peterson