Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Toni's Taxi
 
Posts: n/a
Default protect a workbook from being deleted

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?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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 ToolsProtectionProtect
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
wrote:

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I protect a spreadsheet from being deleted or moved? Dean Excel Discussion (Misc queries) 2 January 7th 05 02:27 AM
copy a workbook from other workbook with lot of sheets wit... Vai Excel Discussion (Misc queries) 1 January 3rd 05 10:27 PM
Resize the workbook window is impossible Valeria Excel Discussion (Misc queries) 1 December 29th 04 11:30 AM
Creating a subbook from a workbook. Chaplain Doug Excel Discussion (Misc queries) 0 December 19th 04 11:31 PM
how can I duplicate or copy a workbook then divide selected cells. macros excel... duplication and calculat Excel Discussion (Misc queries) 1 November 29th 04 03:16 PM


All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"