Dear All

Need guidance for the flg:

1. Sheets to be unprotected but must disable the option to delete any rows
and columns or cells. Is it possbile to enter a code in the worksheet??

2. Any idea to stop deleting the folders in windows bcos in the vb the
current workbook will be saved in a folder but some new ppl come and delete
the folder in windows and the program gives errors.

3. In the program the current sheet is deleted and inserts new data and
renames it to the old sheet name. Due to some wrongful entries the program
aborts after deleting the sheet. In that case when the program is run it
will error as the sheet is not present and hence want a line of vb to say if
the sheet 'report' is missing then Sheets.Add().Name = "report" so that the
program can continue.

Pls help

Brgds/captgnvr