Results 1 to 10 of 10

Prevent Users From Deleting, Inserting Rows and Columns Without Protecting Worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    98

    Prevent Users From Deleting, Inserting Rows and Columns Without Protecting Worksheet

    Hello, is there a way to prevent users from Deleting and Inserting Rows/Columns without protecting the Worksheet?

    The reason I don't want to protect the worksheet is because when someone pastes something into my worksheet, it defaults it to "locked" and then they are unable to use the cell again.

    I know that there is no workaround with "Match Destination Formating as Default" with "Ctrl + V". I have been using a marco for Ctrl +D.
    Last edited by johnph; 07-19-2012 at 03:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1