Hello,
I'm wondering if someone would be able to help with a little macro problem. I'm a complete novice with macros and have had to Google everything for this but it's not helping me with the last problem.
I have a sheet which needs a macro to unprotect the sheet, sort the data then protect the sheet again. I have been able to create the macro however I don't want the spreadsheet users to be asked for the password (although I still want the password there). Every time I run the macro it asks for the password and I don't want it to.
So far I have:
Sub UnProtectSheet()
ActiveSheet.Unprotect
Password="password"
End Sub
then the code for sorting
Sub ProtectSheet()
ActiveSheet.Protect
Password="password"
End Sub
Any help which can be provided would be very much appreciated!
Many Thanks,
Lisa
Bookmarks