Protection

[Esradekan]

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

 

[Gord Dibben]

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/tip/retrieving_the_computer_name_or_logged_in_user_name/

2. Using strongarm tactics to control Excel.

http://spreadsheetpage.com/index.php/tip/using_strong_arm_tactics_in_excel/


Gord Dibben MS Excel MVP

 

[Esradekan]

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/tip/retrieving_the_computer_name...

2.  Using strongarm tactics to control Excel.

http://spreadsheetpage.com/index.php/tip/using_strong_arm_tactics_in_...

Gord Dibben     MS Excel MVP

Helps a lot, thank you so much.

Esra