+ Reply to Thread
Results 1 to 9 of 9

Editable areas

  1. 09-08-2014, 04:38 AM #1
    batya
    batya is offline
    Registered User
    Join Date
    08-02-2014
    Location
    Ashgabat, Turkmenistan
    MS-Off Ver
    2013
    Posts
    23

    Editable areas

    Hi dear members.
    I want to make editable only yellow marked areas in this file. Editable areas.xlsx Can anyone help me with this?
    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 09-08-2014, 05:04 AM #2
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Editable areas

    It could have been a hard job unlocking only yellow colored cells..
    So I have done what you have told .. only on the bordered area..
    check the attached file..
    I have used sheet Protection...
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  3. 09-08-2014, 05:06 AM #3
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Editable areas

    If you wanna exactly target only yellow cell..
    then I can provide you the approach...
    Reply With QuoteRegister To Reply
  4. 09-08-2014, 06:29 AM #4
    batya
    batya is offline
    Registered User
    Join Date
    08-02-2014
    Location
    Ashgabat, Turkmenistan
    MS-Off Ver
    2013
    Posts
    23

    Re: Editable areas

    I think you misunderstood me. I want to make yellow areas editable but others to be locked.
    Reply With QuoteRegister To Reply
  5. 09-08-2014, 08:02 AM #5
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Editable areas

    Thats what I have done .. for the bordered area...
    okay .. let me do it for the yellowed area...
    Reply With QuoteRegister To Reply
  6. 09-08-2014, 08:14 AM #6
    batya
    batya is offline
    Registered User
    Join Date
    08-02-2014
    Location
    Ashgabat, Turkmenistan
    MS-Off Ver
    2013
    Posts
    23

    Re: Editable areas

    Thank you very much
    Reply With QuoteRegister To Reply
  7. 09-08-2014, 10:21 PM #7
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Editable areas

    Check the attached file...
    Mission Accomplished..
    The file has been protected with no password...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 09-09-2014, 12:19 AM #8
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Editable areas

    Hi, batya,

    in case you need a VBA code for this:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  9. 09-09-2014, 12:33 AM #9
    batya
    batya is offline
    Registered User
    Join Date
    08-02-2014
    Location
    Ashgabat, Turkmenistan
    MS-Off Ver
    2013
    Posts
    23

    Re: Editable areas

    Thank you very much you guys for the effort. Damn you are good and fast
    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. Editable list box
    By bharathy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2013, 07:11 AM
  2. [SOLVED] Count rows between two areas in a collection/selection of multiple areas
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2012, 10:38 AM
  3. Pop up, editable text box?
    By rriiser in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-18-2011, 06:27 AM
  4. editable list
    By NewTooExcel in forum Excel General
    Replies: 0
    Last Post: 08-02-2007, 08:52 AM
  5. [SOLVED] Cell is locked but still editable...
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2006, 09:10 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