Posted to microsoft.public.excel.programming

Lucas Reece Lucas Reece is offline

external usenet poster

Posts: 18

Disable row delete in a worksheet (not all worksheets in theworkbook)

Is it possible to prevent deleting of rows in a worksheet within a
workbook? e.g. I have Sheet1, Sheet2, Sheet3 and Sheet4 in the
workbook but only want to prevent deletion of rows in Sheet2.

Can someone offer a solution to this using VBA?

Many thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Countif and Sumif with refrence value a Cell on another Sheet in theWorkbook	Mike 215	Excel Discussion (Misc queries)	3	September 3rd 09 03:51 AM
Disable Worksheet Delete Warning	Charles in Iraq	Excel Programming	1	March 30th 07 08:51 AM
VBA to disable "Delete...." on shortcut menu of worksheet tab?	Mary Kathryn	Excel Discussion (Misc queries)	3	March 3rd 06 05:54 PM
Disable Worksheet Delete Dialog	Greg	Excel Programming	1	March 1st 05 08:32 PM
Disable Add/Delete/Move Worksheets	jamiee	Excel Programming	1	January 5th 04 06:50 PM

All times are GMT +1. The time now is 11:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us