Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent others from running my macros
Hi all,
Very often I have to send my Excel files (with macros) to others. Is there any simple way of preventing third parties from running the macros in those files? Thanks. Frederick Chow Hong Kong. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent others from running my macros
The simple way would be to require a password to run the macro:
Public Sub MyMacro() Const sPWORD As String = "drowssap" Dim vResponse As Variant Do vResponse = Application.InputBox("Password: ", Type:=2) If vResponse = False Then Exit Sub 'User Cancelled Loop Until vResponse = sPWORD 'your code here End Sub Then protecting your code (Tools/Project Properties in the VBE). However, that will not keep anyone with the gumption to find these newsgroups from finding a way to see/run your macros: http://www.mcgimpsey.com/excel/fileandvbapwords.html A more secure way is to put your code in a separate add-in so that it's never sent to the others. In article , "Frederick Chow" wrote: Hi all, Very often I have to send my Excel files (with macros) to others. Is there any simple way of preventing third parties from running the macros in those files? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent others from running my macros
Thanks a lot. A textbox asking for a password is a workable solution.
Frederick Chow "JE McGimpsey" wrote in message ... The simple way would be to require a password to run the macro: Public Sub MyMacro() Const sPWORD As String = "drowssap" Dim vResponse As Variant Do vResponse = Application.InputBox("Password: ", Type:=2) If vResponse = False Then Exit Sub 'User Cancelled Loop Until vResponse = sPWORD 'your code here End Sub Then protecting your code (Tools/Project Properties in the VBE). However, that will not keep anyone with the gumption to find these newsgroups from finding a way to see/run your macros: http://www.mcgimpsey.com/excel/fileandvbapwords.html A more secure way is to put your code in a separate add-in so that it's never sent to the others. In article , "Frederick Chow" wrote: Hi all, Very often I have to send my Excel files (with macros) to others. Is there any simple way of preventing third parties from running the macros in those files? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Excel crash when running | Excel Programming | |||
Prevent A Macro From Running If SpreadSheet is Filtered | Excel Worksheet Functions | |||
How to prevent routine from running on certain sheets | Excel Programming | |||
Prevent end users from manually running or recording macros | Excel Programming | |||
Prevent users from running macros | Excel Programming |