Ok, I know this is gonna be a stupid and easy question to answer and I knew this before but have forgotten how cuz of lack of use but...
I'm using excel from Office 2000, I created an invoice template and when opened I want the focus to be on the first cell where I'm to enter the information. no problem there, but I want all other cells where I don't enter information to be locked so that that info cannot be altered.
when I created the template I went into cell properties and made all the cells where info is to be entered unlocked. Why when I open the saved template are the supposed locked cells allowing me to enter info?
thanks
--jak
edit: nevermind, i figured it out, I had to protect the worksheet under tools>protection....duh.
I'm using excel from Office 2000, I created an invoice template and when opened I want the focus to be on the first cell where I'm to enter the information. no problem there, but I want all other cells where I don't enter information to be locked so that that info cannot be altered.
when I created the template I went into cell properties and made all the cells where info is to be entered unlocked. Why when I open the saved template are the supposed locked cells allowing me to enter info?
thanks
--jak
edit: nevermind, i figured it out, I had to protect the worksheet under tools>protection....duh.