LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Deleting a Sheet

If you Protect the workbook sheet delete will be disabled

ToolsProtectionProtect Workbook

Abdul Salam

-----Original Message-----
Hi,

I am currently using the Sheet_Deactivate event to check

if a user
try's to delete a sheet. Is there anyway to cancel the

actual sheet
deletion after the user has selected Delete on the Excel

message box
that is displayed when deleting any sheet? Basically

what I am trying
to do is stop users deleting a sheet if it has

particular information
on it?

Any ideas?

Thanks in advance..

Rick
.

 
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
Deleting cliparts in excel sheet Karina Excel Discussion (Misc queries) 7 June 3rd 10 06:35 PM
Keep sheet from deleting contents Richard Excel Worksheet Functions 1 March 14th 08 03:24 AM
Deleting a sheet creates a new one laralea Excel Discussion (Misc queries) 6 June 13th 07 12:22 AM
how to protect sheet from adding/deleting Scott Excel Discussion (Misc queries) 1 February 16th 05 05:21 PM
Deleting every-other row in a spread sheet smintey Excel Discussion (Misc queries) 5 December 8th 04 05:08 PM


All times are GMT +1. The time now is 02:18 AM.

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

About Us

"It's about Microsoft Excel"