protect and unprotect workbook using vba code

[jackni]

i'm looking for a vba code to solve the following problem
a .xlsm workbook, the protect workbook passwork is known as "111111", the VBA project password is "222222", and how to write vba code to insert a new sheet, suppose the workbook has three worksheet, now using vba code to unprotect workbook, and auto insert a newsheet, then protect workbook again, whcih the password remains as "111111"
using a commondbutton to do this, everytime you click, insert a new sheet.

hope someone can help, many thanks!

 

[jackni]

michael,

thanks for all your replied posts.
i have upload the excel files and two pictures to the mediafire, the website is http://www.mediafire.com/?0zufu0k3b13qgej
i'm now come up against two problems,
the first is the button in excel files cann't working because the excel disabled macros, and the second is developer ribbon ->macro security-> enable macro buttion missing
i don't konw why, could you fix this for me?

thank you again!

 

[Michael M]

Did you save the file as Macro enabled, which you can do in V7 or higher?
If you don't do this then the workbook, won't be saved with macros included.
I cannot view external files from my current site, I have restictions imposed on my computer.

 

[jackni]

i saved my file as .xlsm
usually my macro works fine, but this time it cann't working, i don't know why...