Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Cell Protection

  1. #11
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another suggestion for this kind of coding is this:
    Don't code totally from scratch!
    Start by recording a new macro that does exactly what you want ( in this case un-protect a sheet ... then protect it again.)

    Once you've recorded the macro go in and edit the macro by inserting you extra piece of code in the middle.

    I find that starting problems this way is great in learning new command and codes.
    <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again,
    I don't why this happens or what i'm doing wrong but this always happens to me . The "_" is an UNDERSCORE
    it is used to contine the line of code to the next line,your code should look like:

    Sheets("100m").Unprotect password:="Carol"

    Sorry for the confusion of the "UnderScore"
    I edited my last post to correct this

    James

  3. #13
    New Member
    Join Date
    May 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thankyou lads you have both been a great help and now i have managed to get it working, i didnt bother with the password in the end but now i know how to add one if i wanted it.

    Im not very familiar with vb i have done a little bit of it and i really should learn it so i know what the hell you and i am going on about!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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