protect a workbook from being deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me if I can prevent an Excel workbook from being deleted
from my file without some sort message being sent to verify this request?
 
Toni

A workbook is a file.

Do you mean prevent a worksheet from being deleted from a workbook?

The alert message is built-in. When you try to delete a sheet you are asked
if you really want to do this.

If that is not sufficient, Protect the workbook under Tools>Protection>Protect
Book.

No way can a sheet be deleted unless the protection is removed. You would
place a password to unprotect for sheet deletion.

Note that workbook protection passwords are easily cracked.

If none of the above assists, post back with your exact needs. There may
another way.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 10:05:08 -0800, "Toni's Taxi" <Toni's
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Protecting Entire Workbook from Deletion 2
Sharing workbooks limitations - Merged Cells 12
prevent the over-write 5
Not a novice - can't delete tabs! 1
protecting a workbook from deletion 2
Workbook protection 3
Protection of workbook 7

Back
Top