HI all,
Someone at work created a macro that sorts sheet 2 by column D. Then copies the first 3 columns into sheet T (B to D) and then sorts that sheet by column1.
They have this bit working ok but would like to protect sheet t to stop people changing things. I tried adding in some code to unprotect the sheet --> then do the macro ----> then reprotect the sheet but its giving errors. Any ideas. Attached is the worksheet
Many thanks,
Chemist
Your code & errors would help
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If you protect the sheet with a macro, you have an option to only apply the protection to the user interface. That way you can manipulate the workbook using VBA without having to unprotect sheets.
Here's an example of a procedure I wrote recently that does that
(along with changing a few protection variables):
Is that something you can work with?Please Login or Register to view this content.
Hi Ron,
Cheers for that. I will certainly give it a go. If im struggling i will let you know. Thanks again,
Chemist
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks