+ Reply to Thread
Results 1 to 2 of 2

Error 1004 while assigning password for AuditLog sheet

  1. #1
    Registered User
    Join Date
    12-03-2020
    Location
    Australia
    MS-Off Ver
    Office 2016
    Posts
    1

    Error 1004 while assigning password for AuditLog sheet

    Hi Team,

    I created a AuditLog sheet to capture the changes in other sheets from same workbook using below code in post2876768 in post#4 but it throws an error 1004 if 'AuditLog' sheet is password protected and it works if it is unprotected. How to unprotect the sheet within the same code and protect it back?

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Error 1004 while assigning password for AuditLog sheet

    Hi CKV747,

    Welcome to the forum.

    Though you could use the macro recorder to get most of what you're after (expect the password text of course), see how this goes:

    Please Login or Register  to view this content.
    Regards,

    Robert
    Last edited by Trebor76; 02-25-2021 at 02:29 AM.
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] issue with macro freeze pane from sheet 1 to sheet 2 getting runtime error 1004
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2019, 01:16 PM
  2. Replies: 1
    Last Post: 08-02-2017, 01:58 PM
  3. AuditLog Issues
    By liveoutdoors9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2014, 01:45 AM
  4. Error:1004 When Password Protected VBA
    By Gopal Veeranala in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2012, 12:14 PM
  5. Password debug error 1004
    By Stormdronk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2011, 03:46 PM
  6. Password protection with grouping causes error 1004
    By michelr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2006, 05:54 AM
  7. Run-Time 1004 password error
    By Bob in forum Excel General
    Replies: 1
    Last Post: 07-25-2005, 06:06 PM

Tags for this Thread

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