Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protection
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |