Hello, The following code (without the unprotect bit) does exactly as it is meant to do, and sorts the rows when then date changes in column H, but not when the sheet is protected.
I have tried to adapt the code to unprotect and then protect again afterwards but it isn't working. Could someone point me in the right direction and explain what I have or haven't done correctly
Thanks
Please Login or Register to view this content.
I see the End If.
Where is the If ?
Gary's Student
make the activesheet the one you want to work on then
ActiveSheet.Unprotect password:="yourpassword"
other code
ActiveSheet.Protect password:="yourpassword"
here's a piece of code from my VBA, the screen updating is turned off to stop the screen flashing
Please Login or Register to view this content.
Last edited by arlu1201; 02-19-2013 at 02:55 PM.
capt_tony,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
capt_tony, thank you for your code and advice, and thank you Jakobshavn for the word on the 'end if'
I have removed the 'end if' and it seems to be working now, unless I've missed the point of your comment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks