How do I protect shapes and buttons in a sheet?

[yajiv.vijay]

I have some buttons and data in a sheet which are mandatory for my
macro. How can I protect the whole sheet. I mean, even if I protect
the sheet with password, I was able to delete it. How to protect the
whole workbook?

 

[paul.robinson]

Hi
There are two levels of protection, Sheet level and workbook level.
The workbook protection protects the structure of the workbook, so
when it is on you cannot unhide sheets, move sheets or delete sheets.
The worksheet protection protects the contents of a sheet, so you
cannot delete data (unless the cell is unlocked using Format, Cells,
Protection and clicking off locked cells. This must be done before
protecting the sheet.) or shapes on the worksheet.
Workbook protection will not protect the contents of any sheet. You
must apply worksheet protection.

regards
Paul