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!!

Hi

You can not delete rows etc. in a protected sheet. A solution could be to
wrote a macro which unprotect the sheet, delete the selected row(s), and
protect the sheet again. The macro can be called from a button on the sheet.

To prevent sheet(s) from beeing deleted, you have to protect the workbook
for structure.

Hopes this helps.
....
Per

"Rose Tamang 2001" <(E-Mail Removed)> skrev i
meddelelsen news222D087-2709-4572-8AE2-(E-Mail Removed)...
> 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!!
>

Check your other post.

On 05/14/2010 05:14, Rose Tamang 2001 wrote:
> 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!!
>