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 |
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 |
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 |
All times are GMT +1. The time now is 01:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com