+ Reply to Thread
Results 1 to 4 of 4

Turn OFF insert,delete Rows/Columns

  1. #1
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    281

    Turn OFF insert,delete Rows/Columns

    Hi guys i am currently using this to stop people from deleting or inserting rows/columns and it works perfectly, but.. it stops it from happening on every sheet.. is there a way to change it so that it only happens on the 5 sheets i need it to? 5 sheets are.. "Chiller AM" "Chiller PM" "Ambient Am" "Ambient Pm" "Register" , Thanks! ( Already been suggested to just protect the sheets, That is not an option but thanks! )


    Please Login or Register  to view this content.
    Last edited by LeeBillington; 08-12-2018 at 03:24 AM.

  2. #2
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Turn OFF insert,delete Rows/Columns

    Heres how I would do this
    Attached Files Attached Files
    Bramz

  3. #3
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    281

    Re: Turn OFF insert,delete Rows/Columns

    Ah yeah thats good, thanks

  4. #4
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    281

    Re: Turn OFF insert,delete Rows/Columns

    Nevermind, Done it!
    Last edited by LeeBillington; 08-16-2018 at 07:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-30-2017, 03:36 AM
  2. Disable insert and delete rows and columns
    By ash2017 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2017, 02:23 AM
  3. Can't insert and delete rows and columns in Excel 2013
    By Rabenja in forum Excel General
    Replies: 4
    Last Post: 01-31-2014, 09:44 AM
  4. Vba to allow user to insert rows/columns but not delete on unprotected sheet
    By Nicola13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 06:19 AM
  5. Insert delete columns and rows using vba
    By herwin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2011, 10:51 AM
  6. How to disable insert/delete columns & rows?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2010, 04:16 PM

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