Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hrvoje
 
Posts: n/a
Default Excel file protection?

How can I protect my excel file from copying?
Is there some way when someone copies file to another computer, that excel
file will not work?

Thanks very much


  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

I think your only protection against someone opening the workbook would be
to use a password during File, Save As.

--
Jim Rech
Excel MVP
"Hrvoje" wrote in message
...
| How can I protect my excel file from copying?
| Is there some way when someone copies file to another computer, that
excel
| file will not work?
|
| Thanks very much
|
|


  #3   Report Post  
Hrvoje
 
Posts: n/a
Default

I think your only protection against someone opening the workbook would be
to use a password during File, Save As.


Yes, but what if someone use copy, paste to floppy disc. In that way excel
is not pretected.
I am asking this as I've seen one excel file which is protected in one way.
I don't know how but is not working on my computer.
It has excel file to enter data, and when you click button makes report in
another excel file.
I would like to have some protection in my excel, even in this way. Is there
some way that excel when opens checks folder from where is open, and if it
is not in right directory doesn't work, or something similar.

Thanks in advance


  #4   Report Post  
Jim Rech
 
Posts: n/a
Default

Yes, but what if someone use copy, paste to floppy disc. In that way excel
is not pretected.

But what good does that do this person? Without the password he cannot open
the file because it is encrypted. It is true that there are programs that
break passwords but if you choose a truly random password like "2#fH^;l45xa"
the password breaker may have to work for years...

How does having a button on a worksheet that runs a macro protect a
workbook? _Any_ kind of protection scheme that involves macros is
inherently very weak. All you have to do is disable macros and it's gone.

--
Jim Rech
Excel MVP
"Hrvoje" wrote in message
...
| I think your only protection against someone opening the workbook would
be
| to use a password during File, Save As.
|
| Yes, but what if someone use copy, paste to floppy disc. In that way excel
| is not pretected.
| I am asking this as I've seen one excel file which is protected in one
way.
| I don't know how but is not working on my computer.
| It has excel file to enter data, and when you click button makes report in
| another excel file.
| I would like to have some protection in my excel, even in this way. Is
there
| some way that excel when opens checks folder from where is open, and if it
| is not in right directory doesn't work, or something similar.
|
| Thanks in advance
|
|


  #5   Report Post  
Hrvoje
 
Posts: n/a
Default

I guess I will put password something like you wrote.

Thanks Jim

"Jim Rech" wrote in message
...
Yes, but what if someone use copy, paste to floppy disc. In that way

excel
is not pretected.

But what good does that do this person? Without the password he cannot

open
the file because it is encrypted. It is true that there are programs that
break passwords but if you choose a truly random password like

"2#fH^;l45xa"
the password breaker may have to work for years...

How does having a button on a worksheet that runs a macro protect a
workbook? _Any_ kind of protection scheme that involves macros is
inherently very weak. All you have to do is disable macros and it's gone.

--
Jim Rech
Excel MVP
"Hrvoje" wrote in message
...
| I think your only protection against someone opening the workbook would
be
| to use a password during File, Save As.
|
| Yes, but what if someone use copy, paste to floppy disc. In that way

excel
| is not pretected.
| I am asking this as I've seen one excel file which is protected in one
way.
| I don't know how but is not working on my computer.
| It has excel file to enter data, and when you click button makes report

in
| another excel file.
| I would like to have some protection in my excel, even in this way. Is
there
| some way that excel when opens checks folder from where is open, and if

it
| is not in right directory doesn't work, or something similar.
|
| Thanks in advance
|
|






Reply
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
Saved *.csv file gives SYLK file type warning upon Excel 2003 open Tom Excel Discussion (Misc queries) 5 March 19th 08 03:15 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 2 February 19th 05 08:52 PM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 04:19 AM
Excel Exits on File Close with Outlook Erin Searfoss Excel Discussion (Misc queries) 1 January 16th 05 09:43 PM
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 01:07 AM


All times are GMT +1. The time now is 06:46 PM.

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"