Protect Button Controls

sonicdemonic
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?

Thanks

Colin Legg
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?

sonicdemonic
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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum