Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Location
    The Farm
    Posts
    35

    Unanswered: Compatibility Mode - Unprotect worksheet not working

    Excel 2007, compatibility mode for Excel 2003 file:

    Can someone please point me to a reference or tell me why worksheet.unprotect in a macro does not appear to work? The macro will fail with "worksheet protected" when run unless I first unprotect the worksheet manually.

    Thanks
    Bartron

    Liv'n down on the cube farm. Left, then another left, then right.

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Please can you show us the code and give us the error number and the exact, full error message?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •