RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Experts,
I have posted this query the link of which I am sharing. The problem to hide and unhide sheets is solved. I am trying to protect the workbook and lock the project, but then the code runs haywire. The code is running perfectly when the sheet original is not protected. But once I protect the sheet Original, protect the workbook and lock the project, the code runs haywire and the code generates an error. I need help in editing the code so that once the project is locked and the workbook is protected, it must run perfectly.
I have posted this query the link of which I am sharing. The problem to hide and unhide sheets is solved. I am trying to protect the workbook and lock the project, but then the code runs haywire. The code is running perfectly when the sheet original is not protected. But once I protect the sheet Original, protect the workbook and lock the project, the code runs haywire and the code generates an error. I need help in editing the code so that once the project is locked and the workbook is protected, it must run perfectly.
Excel Ask & Answer | Facebook
Share your knowledge. It is a way to achieve immortality -- Dalai Lama.
www.facebook.com