[RESOLVED] where do i put this code

Const tmpPassword = ""

Application.ScreenUpdating = False
Worksheets("Sheet1").Unprotect (tmpPassword)
Worksheets("Sheet1").Protect (tmpPassword)

What do you mean were do you put it !!!????

When do you want it to run ?

the excel has option buttons hide columns and buttons if i put unportect and protect do i have to give when i save the command or when the sheet opens

try putting in the click for the option button, see if it does what you want