+ Reply to Thread
Results 1 to 3 of 3

Facing problem while entering data in column A (showing some error message)

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    New Delhi
    MS-Off Ver
    Excel 2003
    Posts
    46

    Facing problem while entering data in column A (showing some error message)

    we are facing issue while entering data in first column of the worksheet. Its showing some error mesaage which is arsing due to some validation problem. And even data validation is also greyed out.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Facing problem while entering data in column A (showing some error message)

    It appears there is some code running in the background
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Facing problem while entering data in column A (showing some error message)

    Good afternoon meetvivek72

    Your workbook is set up as shared and protected. Remove the share functionality and unprotect it and you will then be able to access the data validation which is at the root of your problem.

    HTH

    DominicB

+ 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. Nested If showing error message
    By Weaselwithagun in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2015, 01:06 PM
  2. Facing problem while saving data in desired cell in excel sheet from your form
    By Harmeet Singh in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-23-2013, 03:39 AM
  3. facing error - subscript out of range - In allocating data in sheet name wise
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2013, 05:30 AM
  4. [SOLVED] Facing Problem with VBA Excel on Pulling data
    By nitesh_greatie in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-17-2013, 03:05 AM
  5. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  6. error message 91 when entering wrong data
    By eyesonly1965 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2006, 11:22 AM
  7. [SOLVED] How to print when an error message keeps showing?
    By clueless in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 01:40 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