Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping excel program confidential
I have created an excel program that others will have access to to be able to
enter information on a daily basis. However, I don't want the program itself to be able to used/modified by others. I've done the whole protection thing as far as locking certain cells, but I want to be able to email it out in a read only format. As far as I can tell, they could still save the program under another name and use it from there. Is there any way to protect a file on a computer from being saved to a disc? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping excel program confidential
i spose you could have a macro that copies and pastes everything as a value
with a before save event.Of course someone who knows could probably disable that -- paul remove nospam for email addy! "Nat" wrote: I have created an excel program that others will have access to to be able to enter information on a daily basis. However, I don't want the program itself to be able to used/modified by others. I've done the whole protection thing as far as locking certain cells, but I want to be able to email it out in a read only format. As far as I can tell, they could still save the program under another name and use it from there. Is there any way to protect a file on a computer from being saved to a disc? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping excel program confidential
Try highlighting the entire spreadsheet, then Copy / Paste Special -
Values to a new workbook and mail that to them. ed paul wrote: i spose you could have a macro that copies and pastes everything as a value with a before save event.Of course someone who knows could probably disable that -- paul remove nospam for email addy! "Nat" wrote: I have created an excel program that others will have access to to be able to enter information on a daily basis. However, I don't want the program itself to be able to used/modified by others. I've done the whole protection thing as far as locking certain cells, but I want to be able to email it out in a read only format. As far as I can tell, they could still save the program under another name and use it from there. Is there any way to protect a file on a computer from being saved to a disc? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping excel program confidential
Paul, I appreciate your help. I've never been on one of these message
boards before...pretty cool to get responses. I'm thinking your idea could be effective, however, I don't know the first thing about macros and even the help section isn't too helpful....maybe you could tell me a little more? Thanks so much in advance. Natalie "paul" wrote: i spose you could have a macro that copies and pastes everything as a value with a before save event.Of course someone who knows could probably disable that -- paul remove nospam for email addy! "Nat" wrote: I have created an excel program that others will have access to to be able to enter information on a daily basis. However, I don't want the program itself to be able to used/modified by others. I've done the whole protection thing as far as locking certain cells, but I want to be able to email it out in a read only format. As far as I can tell, they could still save the program under another name and use it from there. Is there any way to protect a file on a computer from being saved to a disc? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working excel files keeping on desktop | Excel Worksheet Functions | |||
I cant open files unless I open the Excel program first | Excel Discussion (Misc queries) | |||
calling a C++ program from Excel 2000 and passing a result from C++ back to an excel spreadsheet | Excel Discussion (Misc queries) | |||
Hyperlink in Excel opens the right program, but can't read file. | Excel Discussion (Misc queries) | |||
Mexport transfer from another program to excel opens at excel lau. | Excel Discussion (Misc queries) |