Controls in protected sheet don't response!!!

[Rose Tamang 2001]

Hi, Geeks!!

1. Can any one tell me if it is possible to activate the controls in the
proctected sheet? One of the control has to delete the rows. I can't!!
2. Any idea to reduce the security level to low through VBA in Excel 2003!!
3. How to protect the sheet from being deleted? I need a VBA code to do this.

Please help!!

 

[Dave Peterson]

#1. Which control do you mean? Is it from the Forms toolbar or from the
Control toolbox toolbar or from somewhere else?

#2. It's a user choice about security. If your code could change that setting,
then any code could change that setting -- even malicious code.

So it wouldn't be much of a security measure for the user.

#3. You could protect the workbook's structure -- no code required.
Tools|Protection|Protect workbook|check Structure

Be aware that this will stop renaming, deleting, inserting, moving of any sheet.