Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect excel workbook from macro starting from Developer - Code ribbon?
Hello,
in my excel workbook project I use a lot of VBA code where I open different external data sources, hide and unhide some worksheets and do things that shoul not be explicitly viewed by normal users. So I protected Visual Basic code with a password what is probably not the best security (?) but it is probably enough for our not so experienced internal users. What disturbs me is but that the user can clicks on Macros icon from the Developer - Code ribbon and then he can see the list of all my programs defined in my Visual basics Modules. And not only see - the user can even run any od these programs alone and on such way ,because of uncontrolled treatment, he can cause unexpected consequences. Is there any way how to disable user from such uncontrolled actions? Ivan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect excel workbook from macro starting from Developer -
Hello Ivan,
You can start by putting "private" in front of your subs. It hides them from the list of macros (you can still launch them if you type the name), but can be problematic if you try to call a procedure from another module. "Ivan" wrote: Hello, in my excel workbook project I use a lot of VBA code where I open different external data sources, hide and unhide some worksheets and do things that shoul not be explicitly viewed by normal users. So I protected Visual Basic code with a password what is probably not the best security (?) but it is probably enough for our not so experienced internal users. What disturbs me is but that the user can clicks on Macros icon from the Developer - Code ribbon and then he can see the list of all my programs defined in my Visual basics Modules. And not only see - the user can even run any od these programs alone and on such way ,because of uncontrolled treatment, he can cause unexpected consequences. Is there any way how to disable user from such uncontrolled actions? Ivan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect excel workbook from macro starting from Developer -
I have suspected the solution of "private" functions and subs but the
problem is exactly in the (un)attainability of such code from the code of worksheets, forms and other modules. As I understand the only way to reach my goal now is to displace all code from modules to worksheets and forms. In this way I lose by all means the universality od modul code!? Ivan "The Dude" wrote in message ... Hello Ivan, You can start by putting "private" in front of your subs. It hides them from the list of macros (you can still launch them if you type the name), but can be problematic if you try to call a procedure from another module. "Ivan" wrote: Hello, in my excel workbook project I use a lot of VBA code where I open different external data sources, hide and unhide some worksheets and do things that shoul not be explicitly viewed by normal users. So I protected Visual Basic code with a password what is probably not the best security (?) but it is probably enough for our not so experienced internal users. What disturbs me is but that the user can clicks on Macros icon from the Developer - Code ribbon and then he can see the list of all my programs defined in my Visual basics Modules. And not only see - the user can even run any od these programs alone and on such way ,because of uncontrolled treatment, he can cause unexpected consequences. Is there any way how to disable user from such uncontrolled actions? Ivan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect excel workbook from macro starting from Developer -
Or simply add an option argument:
Public Sub addSummaryFxs(Optional arg = 3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
VBA button on Developer ribbon can not be clicked | Excel Discussion (Misc queries) | |||
Excel 2007 Record Macro button in Developer tab is not highlighted | Excel Discussion (Misc queries) | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
How to password protect several excel workbook pages using a macro | Excel Programming |