Thread: Protection
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Esradekan Esradekan is offline
external usenet poster
 
Posts: 86
Default Protection

On Mar 6, 12:53*pm, Gord Dibben wrote:
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..._computer_name...

2. *Using strongarm tactics to control Excel.

http://spreadsheetpage.com/index.php...rm_tactics_in_...

Gord Dibben * * MS Excel MVP


Helps a lot, thank you so much.

Esra






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