HOW DO I SET UP A MASTER TEMPLATE SO IT CAN'T BE CHANGED
 

I am trying to set up a master template so the template can not be changed
but each cell can still have information typed in it.

make the file Read Only (right click on it, properties, check read only)
is that what you mean?

I had a similar problem like this and came up with a solution that is
working well for me.

I have two tabs, one where the input is done and one where the template
is that is linked to the input sheet. I lock the template sheet and
allow the user to edit the "input" sheet. This way they can't change
format and spacing, but they can alter the input values.

Actually my users just have to cut and paste a row of about 78 data
points and it data is linked to the tab and then we save that info off
and make a PDF file. If anyone has any idea on how to do this better
or easier, I would be forever greatful. :)

Thanks,

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=380218

Hello Vicki

First of all create the template, then select the cells that you want
users to be able to type in. Once you've selected these right mouse
click, a menu will appear then select Format Cells, select Protection &
then remove the tick from the Locked box. Then select the Tools menu,
then Protection option & then Protect Sheet option enter a password.
This will now only allow users to enter info. into the cells you
previously selected & leave the template part untouchably unless you
unprotect the sheet.

Hope this helps


--
robmeister
------------------------------------------------------------------------
robmeister's Profile: http://www.excelforum.com/member.php...o&userid=24364
View this thread: http://www.excelforum.com/showthread...hreadid=380218

if you save your file as a template (xlt) it wll open as a copy of itself so
the original file is always untouched ie book1 opens as book11 template would
open as template1,and they open as excel workbooks (xls)
--
paul
remove nospam for email addy!



"Vicki" wrote:

I am trying to set up a master template so the template can not be changed
but each cell can still have information typed in it.