robhargreaves
Board Regular
- Joined
- Feb 6, 2005
- Messages
- 85
I only want the users of my spreadsheets to click buttons and fill in certain cells in my workbooks so I have come up with my ideal security scenario.
*Create buttons for close and save to eliminate the need for the menu or the buttons.
*Remove all menus * Toolbars & Toolbar Buttons, formula bar?
*make the page jump to specified cell on data entry "daily" page should any effort to type on any diallowed cell & msgbox saying "Please only enter information into the forms provided"
*Protect against button press when opening workbook
*Tracker in place to record username, altered cell & Input, time & date (file named with dll although still writes to as txt on network drive)
*Stop right click
*Password protect visual basic code diabling option to debug code.
Is there any thing I have missed out, and is all the above possible?
And is there a more secure way of hiding vb code? - like impossible to get through www.lostpassword.Co.Ck
Thank you
Rob
*Create buttons for close and save to eliminate the need for the menu or the buttons.
*Remove all menus * Toolbars & Toolbar Buttons, formula bar?
*make the page jump to specified cell on data entry "daily" page should any effort to type on any diallowed cell & msgbox saying "Please only enter information into the forms provided"
*Protect against button press when opening workbook
*Tracker in place to record username, altered cell & Input, time & date (file named with dll although still writes to as txt on network drive)
*Stop right click
*Password protect visual basic code diabling option to debug code.
Is there any thing I have missed out, and is all the above possible?
And is there a more secure way of hiding vb code? - like impossible to get through www.lostpassword.Co.Ck
Thank you
Rob
