05-30-2008, 08:39 AM
I have protected my worksheets and the workbook. I have buttons controls that are protected but excel allows them to be moved even though they are protected. Am i missing something? Is there a work around?
05-30-2008, 08:46 AM
You mean that users are able to move them around, I assume, as opposed to them moving in line with cells moving underneath them?
When you protected the worksheet did you tick the Edit objects option?
If you did then untick it.
Else, which version of Excel are you using?
05-30-2008, 08:54 AM
That did it. I wasnt sure what that option did. Figure it would stop editing of cells too.
Version is Office Excel 200
Thans for the help.