r/sir
i am protect the excel sheet name '01-09-2015 with password the password is 123456 than i am click on the "add new sheet and name as current date" button copy & paste new sheet but the error was display Run-time Error '1004': please resolve this issue sir than i am click on the "add new sheet and name as current date" button copy & paste new sheet & do not remove the protection on new sheet thanking you sir i am send the attachments sir please see the attchments
just unprotect the sheet before clearcontents
and then protect the same with
Please Login or Register to view this content.
Please Login or Register to view this content.
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
r/sir
please send the another vba macro code for copy & paste protected sheet with protection thanking you sir
Hii please find attached sheet..... setting UserInterface:= True will resolve the issue...
Don`t care, take care...
Regards,
Mangesh
R/sir
this thread are solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks