+ Reply to Thread
Results 1 to 9 of 9

Password debug error 1004

  1. #1
    Registered User
    Join Date
    04-02-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    27

    Password debug error 1004

    Hi All,
    Please Please!!

    Can someone help me with my coding and errors on my excel workbook.
    I have tried the last three days to fix the problem.
    There are hide and unhide coding with a check box in some of the sheets, that hides and unhide columns when the sheet is protected. Then also code to enable the use of outlines (+) when the sheet is protected.
    In the first sheet I have an auto filter that I enable when I protect the sheet with my password.
    The problem I think is when I close the sheet and reopen it, it protects everything on its own and changes my protection setting ex: I can’t use the auto filter and also you can select the protected cells that I checked to disable when protecting my sheets.
    The errors I get are runtime errors, debug 1004.
    I know this may be a lot to ask, but would appreciate the help.
    Thanks in Advance!!

    Please find uploading.com link for my file.http://uploading.com/files/45c23e75/...Projects.xlsm/

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Password debug error 1004

    Is it possible for you to upload using the tools from this forum?
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    04-02-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Password debug error 1004

    Hi Mordred, Thanks for willing to help.

    Sorry, but the file is to big for me to post on this forum. (10meg)

    Will appreciate the help!!

  4. #4
    Registered User
    Join Date
    04-02-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Password debug error 1004

    Please guys help with the ploblem, still can figure out what im doing wrong??

    The 2 macros are as followed.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Password debug error 1004

    Have you zipped the file?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Password debug error 1004

    Is this what you want?

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-02-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Password debug error 1004

    http://uploading.com/files/e53feb16/...BProjects.zip/

    Hi,Roy

    I have ziped the file, its now 2.4 meg, but I think still to big for the forum??

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Password debug error 1004

    Is the code that I posted working?

  9. #9
    Registered User
    Join Date
    04-02-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: Password debug error 1004

    Hi, Sorry I was out, no I stil get the same error message, maybe it is a different problem. Please can you look at the file I uploaded.

    Thanks.

+ 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