Excel 2010 VBA unprotect password - run time error 424 Object required
Executing the following script over 8 worksheets
Receive runtime error '424' - object required
Fails at the step after reprotect sheet 2 and on unprotect sheet 6 as highlihted below
All worksheets are in Protected Mode before script executes
Script looks for value less tha 1 in column M of selelcted rows and hides the row
Works fine on Sheet 1 , Sheet 5, Sheet 2, and then fails at step starting Sheet 6 which reads
Please Login or Register to view this content.
Last edited by Leith Ross; 09-23-2012 at 08:08 PM. Reason: Added Code Tags
Hello and welcome to the forum.
Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
edited text is taht now OK
no you need to add code tags
Josie
if at first you don't succeed try doing it the way your wife told you to
Executing the following script over 8 worksheets
Receive runtime error '424' - object required
Fails at the step after reprotect sheet 2 and on unprotect sheet 6 as highlihted below
All worksheets are in Protected Mode before script executes
Script looks for value less tha 1 in column M of selelcted rows and hides the row
Works fine on Sheet 1 , Sheet 5, Sheet 2, and then fails at step starting Sheet 6 which reads
Sheet6.Unprotect Password:="arc"
What additional object is required?
Please Login or Register to view this content.
that means you don't have a sheet whose codename is sheet6
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks