Apply Macro First UnprotectSheet After Apply Macro ProtectAgain Solved by : Sixthsense
Hello evryone
i using this code to filter but
when my sheet is protect there is an debug ( U can't use this command in protect mode first Unprotect then apply command )
i want when i apply this code first unprotect my sheet then after applying code protect again
thanx a lot
Please Login or Register to view this content.
Last edited by HaroonSid; 04-02-2014 at 05:32 AM. Reason: solved
Try like this...
In the below code change the Abc to your sheet password
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
yeh!
worked fine as i wanted thaxn a lot frnd
BestRegards
haroon2015
You could protect the sheet using the UserInterfaceOnly parameter of the PROTECT method - that allows code to modify the sheet but locks out interactive changes by the user...
Hi cytop,
That UserInterFaceOnly method will be lost from excel memory once the file is closed and reopened.
It should be re-protected on each time at workbook_open event by enabling the UserInterFaceOnly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks