PDA

View Full Version : Need help to create template



mimimomo
03-09-2008, 11:47 PM
Hi everyone,

I have an idea to create a template but as a beginner in VBA, not sure how to go about it.. My idea is to create a template with, say, 6 columns (A-F). Since this will be a shared template, I need to ensure that no one changes what the other person has inputed.

Once a row is completed (all 6 columns are mandatory) and the user saves the workbook, the completed row will automatically be protected (no formatting/deletion/insertions) are allowed. And also I would like to know when did the user save the inputs in column G (save date/time)...

So when someone input and saves the workbook, the next user can only input in the next row.

Can anyone show me how does the macro look like for this?

Big thanks!

Bob Phillips
03-10-2008, 01:48 AM
Try this http://cjoint.com/?dkjWH5eY84