The attachment has a macro which archives data from sheet 1 to sheet 2. I need to password protect sheet 2 columns A,B,C so they cannot be modified (unless running the macro) excepting for column D which contains comments data that need to be added manually.
Any help welcome
In order to protect the columns you wnt you will need to press Ctrl+A then righ click the highlighted area>Protection> uncheck the locked checkbox so nothing is in it and hit ok, now highlight your columns you want protected and do exactly the same except this time make sure it has a tick in it.
Now protect it with a password, at the begining of your macro use Sheets("Sheet1").Unprotect Password:="whatever your password was" thats assuming its sheet1 your protecting then at the end of your code before End SUb add Sheets("Sheet1").Protect Password:="whatever your password was"
Hope that helps!
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks