Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Copying of Excel Workbooks in 2000 and 2003.
Is there a way of preveting a user to copy an excel workbook to a different
folder location? We have excel spreadsheets saved in our company network and the locations are the one safe source of information. These workbooks contain data which is linked to other workbooks so it is importnat the files are not renamed nor moved to a different folder. No matter how much I communicate this, some people insist on doing it. I know there is VBA code which can disable the use of 'Save-As' so that the files cannot be saved in a different location. However this does not prevent someone from copying (CTRL +C) and pasting (CTRL +V) the file from one folder to another. I need to keep the Save As function as I need to control the read only and modify access passwords etc from the general options. Apparently it is possible to write VBA code which contains the true location of the file, and when the workbook is opened, it ckecks that if it was opened from the specified location, and if not an error message or userform appears informing the user that the workbook cannot be accessed and therefore information cannot be populated. I have also been told that rather than a pop up error message or userform, the worksheets which need accessed are hidden and another worksheet will show instead with the error message. Can anyone help with this. Thanks. Darren |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROBLESM IN COPYING BETWEEN WORKBOOKS AFTER EXCEL 2003 UPGRADE | Excel Discussion (Misc queries) | |||
problem copying visible cells from 2000 to 2003 | Excel Discussion (Misc queries) | |||
Workbooks.Open 2000 vs 2003 | Excel Programming | |||
IN EXCEL 2000 HOW DO YOU PREVENT TEXT FROM GOING INTO THE NEXT COL | Excel Discussion (Misc queries) | |||
Prevent Save in Excel 2000 | Excel Programming |