Macro Giving Error On Protected Sheet
Hello friends kindly help me i've many sheets and macros in my workbook. Everytime i open my file it'll automatically run MACROS from (ThisWorkBook).
Here is the code
Please Login or Register to view this content.
If i unprotect my Sheet11 then it's working fine but when i'm trying to protect this Sheet(Sheet11), it'll give me error.
Sheet11 code
Please Login or Register to view this content.
kindly help me please
thanks in advance
Last edited by isc0rpi0; 03-05-2013 at 06:26 AM.
Hi, isc0rpi0,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks for letting me know i'll keep that in mind
Originally Posted by HaHoBe
got solution from some random thread thanks a lot guys
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
will do that in future
What about this thread? What if someone is looking for the solution?
Please Login or Register to view this content.
Last edited by isc0rpi0; 03-12-2013 at 11:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks