Thread: Protection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default Protection

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