[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[_2_]]

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

[Esradekan]

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