1. I have an Excel sheet which is protected. Is there any way to unprotect the sheet using VBA Codes?

2. I have an Excel sheet with macro, in which the project is locked and I have forget the password. Is there any way to unlock the project?

3. I have created a macro and whenever I open that macro, it is asking for 'Enable/Disable' option. Actually I need it to be enabled automatically without displaying an alert?

4. Whenever I try to insert newsheet it will be inserted towards left of the current sheet. Is there a way to get it inserted towards right of current sheet?