On Monday 22 October 2007 17:21:07 Woolston Craig A Civ 518 SMXS/MXDEA wrote: > Dear Sir, > > > > I am attempting to build a spreadsheet to track status. As part > of this spreadsheet I am adding controls to be specific I am > adding checkboxes. I had hoped to be able to make a template > sheet with the checkboxes and then just copy the sheet and rename > it. The problem I am having is when I copy the sheet with the > checkboxes on it the checkbox linked cell points back to the > template page as opposed to the new page that I want it to point > to. Is there a setting that I am missing or do I have to > manually change the linked cells every time I copy the template > page? > > > > Thank you for your help, > > > > Craig A. Woolston > > [EMAIL PROTECTED]
Try saving the .ods as a real template file .ots . Go to File > Templates > Save This might make the checkbox links stay where you want them. -- http://24.197.142.167/~jack/openofficefaq.php Read the OpenOffice.org FAQ Microsoft users go to http://www.pclinuxos.com for a great user friendly Linux experience! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
