+ Reply to Thread
Results 1 to 2 of 2

Error on unprotecting worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    10-16-2009
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Error on unprotecting worksheet

    Gurus'

    I require your help for a study project *** POC.
    In brief, I am having a password protected file, the password for which I am reading from a text file. the password characters are briefly copied to sheet3, during the run time, and then cleared on closing the file.
    FYI, the initial password is 1234567.

    But since sheet3 is password protected, it is not able to write to this sheet and that's the error I am getting.
    Place the text2.txt in the c:\ drive, and then open the excel file.

    Pl help me out, since I am nearly finished doing this except for this error.
    Attached Files Attached Files

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

    Re: getting error while trying to unprotect a worksheet

    Why protect the workbook?
    Could you not have the password verification in your code?

+ 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