+ Reply to Thread
Results 1 to 2 of 2

Excel is not accepting any character entries

Hybrid View

  1. #1
    Rick
    Guest

    Excel is not accepting any character entries

    Excel 2003
    A worksheet I made and now want to edit will not accept any character entry
    or editing. All options seem to be grayed out. This has never happened to
    me before and to my knowledge I did not lock/protect the worksheet.
    Thank you.

  2. #2
    Trevor Shuttleworth
    Guest

    Re: Excel is not accepting any character entries

    Rick

    all cells are, by default, locked. This only has any effect if the
    worksheet is protected. I suspect that either you, or someone else, have
    protected the sheet.

    Check under Tools | Protection and see if you get an option to unprotect the
    sheet. If you do, that's your problem. You may have a blank password but,
    failing that, you'll need to run a VBA routine to find the password and
    unlock the sheet. Not as big a problem as it sounds. Post back if you need
    the routine or search the Google archives for a copy

    Regards

    Trevor


    "Rick" <Rick@discussions.microsoft.com> wrote in message
    news:64DA4193-D7DD-4B80-AFAB-1BD9BBB528BA@microsoft.com...
    > Excel 2003
    > A worksheet I made and now want to edit will not accept any character
    > entry
    > or editing. All options seem to be grayed out. This has never happened
    > to
    > me before and to my knowledge I did not lock/protect the worksheet.
    > Thank you.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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