Hi I have this code that will run when something entered into C3.
I can't get it to run properly as I get error saying the sheet it still locked
If I step through the code (F8) it works but not if I let it run
Your advice will be much appreciated!
Please Login or Register to view this content.
Is cell C3 unlocked?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Yes it is
If I step through code it works - why wont it work if it is left to run
I thought that adding the 10sec delay will give whatever in background to work before refreshing data but it seems that not it
I disabled these two lines of code:and tried it in a dummy file and it worked for me. Can you attach a copy of your file. De-sensitize it if necessary.Please Login or Register to view this content.
I need the RefreshAll line in as I want data to Refresh before protecting the sheet again
I just disabled those lines because I had no data in my dummy file. The 'Unprotect' and 'Protect' worked properly without an error message.
In mine I have external data that is refreshed when the value of the cell changes
Any suggestions on modifying my code to make it work
Thank you for you time on this !
Just as a test, try leaving the sheet unprotected and remove the 'Unprotect' and 'Protect' lines from the macro? See if that works for you.
Sorry...try with all sheets unprotected.
I unprotected sheet
Then commented out the unprotect / protect lines
.... it worked!
*scratching my head*
Me too.Could I suggest you start a new thread explaining the problem .... it works without the protection but not with the protection?
Instead of having a loop to unprotect how may I say like ...
Sheet(0).Unprotect password = xyx
Sheet(1).Unprotect password = xyx
THanks!
UseReplace Sheet 1 with the sheet name. You will have to repeat this line for each worksheet. I don't think the looping is the problem, however.Please Login or Register to view this content.
No you are right BOTH ways I get the same error
It's like the RefreshAll is running before the Sheets are unprotected .... weird!
Try this line:in stead ofPlease Login or Register to view this content.Please Login or Register to view this content.
Hey Mumps
Guess what ... it didn't work
Have now figured out that the RefreshAll doesn't get enough time to run, the sheets are then Protected again ...hence getting the error.
Seems that 'DoEvents' is not working
Code is fun !
Thanks so much for your help so far!
Instead of Do Events I tried
continue to Protect sheetsPlease Login or Register to view this content.
But that didn't work either
I finally got it to work
Love code .... sometimes!!Please Login or Register to view this content.
Glad it worked out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks