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