Hello everyone,
We have made a form in excel using macros. The data entered in first sheet gets saved to second sheet. We want the second sheet to be protected. However when we are protecting the second sheet, the macros is not running and reflecting code error. Kindly assist with how we can protect the second sheet and run the macros at the same time.
Hello PrakharBichpuriya,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
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]
Welcome! The more members, the better we can help eachother!
Hello PrakharBichpuriya and Welcome to Excel Forum.
Please start a new thread for your issue in the Excel Programming / VBA / Macros forum.
Also make sure the name of the thread describes the issue, perhaps something like: "protect a sheet and run macros at the same time"
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks