Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Protection
Hello All,
I would like to develop a VBA whereby users are only able to access the Excel file if they run the VBA code. Is there any way of doing this. I can stop users (via code): Closing Userforms etc. Deleting/Adding rows and columns Disable the menu Another thing I thought was to protect the Workbook and only Unprotect it via VBA code. If the user choses "Disable Macros" at the security prompt, then they will have full access to the data. Is there a way to stop this. Reason why I want this is because the application will be one where employess can book their annual leave. Each person has a limited number of days they can book and on each day only a limited number of employees can be off. As you can imagine if they have full access they can book what they want! Any suggestions as to what I can do? Thanks in advance. Chas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection on excel file | Excel Discussion (Misc queries) | |||
Remove file Protection from an Excel workbook file from others | Excel Discussion (Misc queries) | |||
Excel file protection? | Excel Discussion (Misc queries) | |||
Excel file protection again? | Excel Discussion (Misc queries) | |||
Excel file protection? | Excel Programming |