Code to detect if sheets have been moved or deleted

**Newbie_Nick** · 03-19-2010, 02:50 AM

I've written a rather large macro which uses sheet indexes. As a consequence even deleting or moving sheets which are not relevant to the code causes an error.

Is there any way of detecting if sheets have been moved / removed so I can generate a warning for the user.

Thanks
Nick

**JeanRage** · 03-19-2010, 02:54 AM

Hi,

Yes ... (with Excel ... the answer is always Yes ) it can be coded...
but it would be simpler for you to protect your worbook in order for your users not to ruin your work ...

HTH

**Newbie_Nick** · 03-19-2010, 03:11 AM

Originally Posted by JeanRage

Hi,

Yes ... (with Excel ... the answer is always Yes ) it can be coded...
but it would be simpler for you to protect your worbook in order for your users not to ruin your work ...

HTH

Can I protect the workbook and still allow users to modify the data?
Also, preventing sheet deletion is a simple matter, can I also prevent users from moving them?

**JeanRage** · 03-19-2010, 03:29 AM

The answers to your questions are again ... positive

For the users to input data, you need to unlock the ranges they will be using ...

Should you need more info about Protection, never forget F1 ...for help and examples ...

HTH