You probably protected the wrong sheet and you are getting an error some
place in th code or you added a break point in the code. You sholdn't
be seening the VBA editor unless you have an error. Do the following


1) Check all your worksheets/cells to see which are protected and which
aren't protected. Go to the menu to protect a sheet. If it says
protect , then it it not protected. If it say Unprotect, then it is
protected.

2) Change your code to specify the shet you want to protect by name,
not active sheet.

from
Activesheet.Unprotect ("My_Password")
Activesheet.Protect Password:="My_Password"

to
Sheets("Sheet1").Unprotect ("My_Password")
Sheets("Sheet1").Protect Password:="My_Password"


3) Change you error trapping to trap on all errors

VBA menu

Tools - Options - General - Error Trapping - Stop on All Errors

Errors often cause macro to stop.

4) Remove all "On Error Resume Next" and other error statements. Again
Errors often cause macros to stop


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170651

Microsoft Office Help