Getting macros to go around password entry

Dear Forum.
I have been trying to compile a spreadsheet for project cashflow. I want other people to enter project progress as the project progresses, however I don't want them to be able to generally edit the workbook, and therefore have the 'Protect Worksheet' ultized with a password. I have a few macros (activated by clicking on buttons). One of these macros is to make a new month (which creates 12 different columns).
Since the worksheet is protected it prompts for the password prior to being able to create the new columns. I have found that if I run the macro once and enter the password, that the next time it is run (without closing the worksheet), that it performs the macro without prompting for the password again. However, I was antisapating putting this workbook on a network location for various people to open and update their end of progress reporting and do not want them to have the password.
Is there an easy way around this? Either in the VBA used or in how I would 'host' the workbook?
I am just starting to fumble my way through creating macros so the more basic the better
Thank you for any help you can provide.

hi Cidona,

Look up the protect method in the vba Help files and read the section on "userinterfaceonly:=True". (Note that this needs to be re-applied each time the file is opened & this is often done within the Open event macro of the THisWorkbook module.

hth
Rob

Cool, I'm pleased I could help
Thank you for adding to my rep' & marking the thread as Solved.

Rob

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

huh?
That's strange, I must have been seeing things - I'm sure I saw a "Solved" marker, but I guess I just saw Cidona's Edit Text.
oh well, it's done now

Rob