+ Reply to Thread
Results 1 to 2 of 2

Can't disable direct cell editing

  1. 01-16-2017, 11:42 PM #1
    larry909
    larry909 is offline
    Registered User
    Join Date
    01-16-2017
    Location
    USA
    MS-Off Ver
    Office Professional Plus 2013
    Posts
    1

    Question Can't disable direct cell editing

    Hi, trying to disable direct cell editing. Unchecked box: "allow editing directly in cell" in options, but still able to edit cells directly
    Reply With QuoteRegister To Reply
  2. 01-17-2017, 05:07 PM #2
    PeteABC123
    PeteABC123 is offline
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Can't disable direct cell editing

    You need to lock the cell(s), and then protect the workbook.
    Pete
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] protect sheet disable editing of non empty cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2016, 08:21 AM
  2. Need Help to disable cell editing if putting current date + two days
    By Louapril in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2016, 02:54 PM
  3. How to disable direct cell editing by typing, but allow formulas?
    By matkiros in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2012, 07:04 AM
  4. Prevent direct editing, but allow userform to update cell
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2011, 05:09 PM
  5. disable cell content editing, but allow row/column removal
    By Heliux in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2009, 11:18 AM
  6. Disable Editing a Cell Without Protecting the Worksheet
    By akabraha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2008, 06:46 PM
  7. Disable CommandBar buttons while editing the cell
    By Vinit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2005, 03:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1