+ Reply to Thread
Results 1 to 3 of 3

Make a Cell read only

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Make a Cell read only

    r/sir
    i am insert a vba macro code to make a cell read only than i am click on the button the calls was make a read only than second time i am click on the this button the the error was generate this vba macro code only make a cells read only please edit this vba code to remove the cells read only
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Make a Cell read only

    Because you are not again unprotecting the sheet to lock unlock the cells.... codes are little changed...

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Make a Cell read only

    also please mark this thread as solved if it done.. http://www.excelforum.com/excel-gene...ml#post4212105

    Also don`t forget to "Add reputation" to answer if answers work..

+ 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. [SOLVED] How to Make a Cell Read only depending upon Value of another cell
    By nav_nav2000 in forum Excel General
    Replies: 2
    Last Post: 11-19-2013, 02:41 AM
  2. how do you make a cell read only the decimal
    By bansot in forum Excel General
    Replies: 3
    Last Post: 07-01-2013, 01:45 PM
  3. Open in read-only, make changes, and back to read-only??
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2012, 01:00 PM
  4. Make a column/row read only
    By lavina in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 06:26 AM
  5. How to make a macro run only if not READ ONLY
    By jgriffith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2011, 09:16 AM
  6. [SOLVED] how to make cell read only
    By ndalal in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2009, 03:52 AM
  7. Make one particular worksheet read-only
    By Anirudh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2008, 02:28 AM
  8. [SOLVED] How to make a cell read only
    By Little Master in forum Excel General
    Replies: 1
    Last Post: 10-29-2005, 09: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1