LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 331
Default Working from a Protected File

Thanks, I think I know what happend, the original file was built and and
saved as .XLS file, when it was re-saved as .XLT, it opened as the normal
..XLS file. So, do I need to build the original file as an .XLT template
only? I can't build the file as .XLS and save later as an .XLT?


"Gord Dibben" wrote:

You saved as I instructed?

The file you sent had an extension of .XLT?

How did the other person open the file?

Right-click and "Open" would open the original as filename.XLT

Double-click to open would open a copy as filemame1.XLS


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 13:26:18 -0700, Greg
wrote:

Thanks for the response. However, this did not seem to work, I did save my
file as a template and sent it off to another person as a test. The original
file opened and not a copy. Is there something else needed?


"Gord Dibben" wrote:

Greg

Easiest method is to save the original as a Template..........FileSave
AsFile TypeMS Excel Template(*.xlt)

Now whenever that file is opened, a copy opens. The original is never
touched.


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 11:10:07 -0700, Greg
wrote:

Is a way that I can password protect a file so that no changes can be made to
the original file, but if I want to allow someone else to view that file,
they can copy the information into another file and work from that file?

Thanks for the help.
Greg






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto filter sort ascending not working while sheet protected TommyB Excel Worksheet Functions 6 March 17th 10 02:51 PM
Find Function not working on protected sheet Hippy Excel Worksheet Functions 1 December 14th 06 03:14 PM
protected sheet arrow keys not working on unlocked cells JVFRAN Excel Discussion (Misc queries) 0 October 16th 06 07:17 PM
Protected Worksheet - tabs stop working in certain areas bucketowater Excel Discussion (Misc queries) 0 January 26th 06 05:27 AM
Filter not working in a protected file jijy Excel Worksheet Functions 1 August 3rd 05 06:02 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"