alta77
Programmer
- Jan 20, 2009
- 6
I Protected a sheet in Excel using VBA. Now only some parts of the sheet is locked and some parts not. I used took away the locked cells. Why is only protecting parts !! Is it because of name ranges !!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Strange Behaviour !! Help
- Thread starter alta77
- Start date
- Status
Maybe some of the cells are formatted as unlocked. Look at Format Protection for those cells.
As for your sentence "I used took away the locked cells." ... I have no idea what that is supposed to mean!?!?
Cheers, Glenn.
Beauty is in the eye of the beerholder.
As for your sentence "I used took away the locked cells." ... I have no idea what that is supposed to mean!?!?
Cheers, Glenn.
Beauty is in the eye of the beerholder.
- Status
Similar threads
- Locked
- Question
