Given the weakness of Excel security I would say there is no way to ensure that
sort of protection can be found.
The best you can do to keep out unsophisticated users is to use a workbook_open
event to grab the computer name and close the workbook if not that specific
machine.
This would require enabling macros and having a contingency plan in the case
macros were not enabled.
See John Walkenbach's site for some tips.
1. Retrieving the machine name.
http://spreadsheetpage.com/index.php...n_user_nam e/
2. Using strongarm tactics to control Excel.
http://spreadsheetpage.com/index.php...tics_in_excel/
Gord Dibben MS Excel MVP
On Sat, 5 Mar 2011 13:28:25 -0800 (PST), Esradekan wrote:
Hope someone can help.
Is there any way that a 'protection' can be put on an excel workbook,
that will allow that workbook to be run on a specific machine only?
TIA
Esra