+ Reply to Thread
Results 1 to 10 of 10

When protecting workbook with pw, unlocked cells are still locked

  1. #1
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    When protecting workbook with pw, unlocked cells are still locked

    I have had a workbook that has 2 sheets.

    When I protect the main sheet with a password, the unlocked cells are also locked.

    When I move my cursor over any cells, it has the pointed finger as though it has a macro over it, which it doesn't.

    When I click on any cell, the screen flashes and a large part of the screen momentarily it looks like a selected area.

    I also am using Freeze Panes. Removed the Freeze and still no good.

    If I use the horizontal scroll bar and click the right arrow 3 times, they become unlocked.

    If I move the screen 3 clicks to the left, it re-locks all of the unlocked cells.

    I do know how this function works. I use it alot. But, this is crazy.

    Any ideas?
    Last edited by Launchnet; 12-18-2009 at 12:53 AM.
    Thanks for helping . . .
    Matt @ Launchnet

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: When protecting workbook with pw, unlocked cells are still locked

    Have you been deleting a lot of rows that have had buttons?

  3. #3
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: When protecting workbook with pw, unlocked cells are still locked

    No. I have not deleted any rows with buttons. After this happened, I deleted about 10 rows at bottom of sheet and the same with columns to make sure something had pushed something out some how.

    Have to leave for 1 1/2 hours now. Church.

  4. #4
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: When protecting workbook with pw, unlocked cells are still locked

    Just back from Bible Study and came up with an idea.

    I unlocked the workbook.
    Then, I unlocked the total worksheet via Format cells
    Then, I locked the workbook again and all cells should be unlocked.
    But, the same condition exists.

    Tomorrow, I am going to try copying all my macros into a new workbook and then gradually re-structure. I will test every so often to see where and if it happens again.

    Hope someone can come up with a solution before I have to do that.

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: When protecting workbook with pw, unlocked cells are still locked


  6. #6
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: When protecting workbook with pw, unlocked cells are still locked

    Hi Dave . . .

    I checked out your suggestion. That is exactly what is happening to my spreadsheet.

    Is there any correction for this problem?

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: When protecting workbook with pw, unlocked cells are still locked

    You can use a code to delete all the butons

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: When protecting workbook with pw, unlocked cells are still locked

    Hi Dave . . .

    I don't use actual buttons. I use a blank clear text page over a cell in this application. I like what I can do with them.

    I have never had this problem before.

    I tried the button delete code, but the macro links did not get erased.

    I could delete all of the links and see if the problem goes away.

    Do you think this would do any good?

    Or, do you have any other ideas?

  9. #9
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: When protecting workbook with pw, unlocked cells are still locked

    I suppose you will have to supply a sample workbook that shows the problem.

  10. #10
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: When protecting workbook with pw, unlocked cells are still locked

    Hi Dave . . .

    Well, I decided to re-do the program on a new worksheet. It now works fine. Thanks for the link.

    It sure would be nice if there was a way of deleting all Excel links. It would also be nice if all Internet links could be deleted from spreadsheet.

    I'll mark the post "SOLVED".

+ 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