ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/19483-spreadsheet.html)

Dan Danes

spreadsheet
 
I want to create a workbook. Then I want to freeze that
workbook so that it can not be changed.
I want people to open it, and do a save as and name that
workbook something else. Then, I want the new workbook to
be fully editable.
Is this possible?

Dan

Duke Carey

Sounds as though you want to save your file as a Template. Excel knows to
open a copy of template files, not the file itself. If the template is named
DansTemplate.xlt and a user opens it, they'll see a new workbook named
DansTemplate1

Look at 'Create a template' in the help file

"Dan Danes" wrote:

I want to create a workbook. Then I want to freeze that
workbook so that it can not be changed.
I want people to open it, and do a save as and name that
workbook something else. Then, I want the new workbook to
be fully editable.
Is this possible?

Dan


Dan Danes

Thanks Perfect.

dan
-----Original Message-----
Sounds as though you want to save your file as a Template.

Excel knows to
open a copy of template files, not the file itself. If

the template is named
DansTemplate.xlt and a user opens it, they'll see a new

workbook named
DansTemplate1

Look at 'Create a template' in the help file

"Dan Danes" wrote:

I want to create a workbook. Then I want to freeze that
workbook so that it can not be changed.
I want people to open it, and do a save as and name that
workbook something else. Then, I want the new workbook to
be fully editable.
Is this possible?

Dan

.



All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com