+ Reply to Thread
Results 1 to 2 of 2

Edit specific range in protected worksheet

  1. #1
    Rao Ratan Singh
    Guest

    Edit specific range in protected worksheet

    Dear Sir/Mam,
    I have a workbook with multiple worksheets. I protected a sheet but some
    menu does not work when it is protectd. e.g. i want to go edit > fill >
    series.

    How it can be possible.

    Thanks in advance

    Rao Ratan Singh

  2. #2
    Bob Umlas
    Guest

    Re: Edit specific range in protected worksheet

    If it's protected, you simply can't. You'd have to unprotect it first. Or
    write a VBA procedure to unprotect, do the fill series, reprotect.
    Bob Umlas
    Excel MVP

    "Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
    news:FF6C347C-1BEE-40D3-ADE1-E617A7033F0D@microsoft.com...
    > Dear Sir/Mam,
    > I have a workbook with multiple worksheets. I protected a sheet but some
    > menu does not work when it is protectd. e.g. i want to go edit > fill >
    > series.
    >
    > How it can be possible.
    >
    > Thanks in advance
    >
    > Rao Ratan Singh




+ 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