Vba Require Password To Run Macro

[Karren Bangura]

ThanksI am using the type text macro and the letters (encrypted) do appear in the box but they do not operate the password. If I insert the macro into a normal word document then the letters appear as expected.

System is 10.12.1

The system password dialog needs to be frontmost when this AppleScript is run from an Execute an AppleScript action (text-script). Try running it in isolation before adding it to any macro sequence.

However if I reopen the workbook as a user, who will not have access to the VBA code, the macro will not run until the VBA password has been entered. I am guessing that the reason is the function is 'outside' of the sub-routine but putting inside the sub-routine won't allow the macro to run. I do not want the user to access the VBA code, they only need to run the macro.

In my company, we have an extensive set of VBA add-ins (.xla and .xlam) that are password-protected (and even digitally signed for security and to prevent tampering). A lot of them reference each other in an attempt to structure them as "clipboard add-in", "general utils add-in", etc. in order to keep their size and functionality separate. In this example, the general utils add-in keeps a reference to the clipboard add-in in order to call "Public" functions from it (you can't call Private routines across modules or from the workbook).

Only we know the passwords to the add-ins, but the client can call "Public" functions and subs without any issues, the same way we call such functions and subs between our add-ins. We also have a huge set of "Private" routines inside the add-in modules, but that's ok since they're used internally only.

We also supply a set of workbooks that make use of those add-ins by having references to a number of the add-ins, which are also protected. However, all the functionality is available to the users and we even have an unprotected VBA add-in that hosts our VBA API -- a thin layer of Public routines that map into the protected code.

Clients do not need to know what's going on inside the add-ins. The only thing they need to know is the publicly available API add-in that we supply and they can use it to automate all sorts of things.

This workflow has around 30 different queries and 6 fields to update dynamically. With regular dynamic input, it is working. I recently received a requirement that the dynamically updated script should be included to the output. This means I should repeat text/action pair 180 times which it is time consuming and increase the complexity. This is why I created a basic macro. Please see partial work below.

The text inputs have SQL scripts. I union all into one file. This gives me a flexibility when I need a change on any script without interfering the others. Then I used find/replace to change the values dynamically by getting user inputs from text interface tool. .

If your intent is to upload to Alteryx Gallery, it is my understanding that InDB connections must be made with Files instead of Shared Connection. See here for more info. -Server-Discussions/IN-DB-Data-Connection-on-Server/m-p/3173...

You're right (and confussed one more time with regular tool). As soon as they have DSN name defined on their machines, I will be good. Most likely we use same name, this will not be an issue. If the user don't have access to the table, it will be denied.

Publishing to the gallery is still a challenge. I know I should use File DSN, I don't like to do this. I think I will avoid publishing to the gallery for now, and the tool will be used by only my team, I think I'm OK.

I had an idea to assign my keyboard's macro keys to various passwords so I can just hit the key and it will paste in (the passwords are long and random so I won't remember them). This is on a home desktop PC. Are there any reasons this is a bad idea security wise?

Instead, use a password manager. An offline password manager allows you to store your passwords in an encrypted form, protected by a master password. Many offline password managers also include functionality to write your password for you, just like a macro, except that this is much safer.

In lots of cases, this is pure advantage. And even if the environment is dangerous, there is an option to store passwords not in keyboard, but in separate additional mouse which is only plugged/used for storing passwords. This way it gets closer to classic pen and paper storage.You will get separate additional mouse as soon as you brake wheel on the previous one.

This is exactly main question, but some mouses support IO only under USB 3.0. So you can plug in 3.0, write passwords, then always use USB 2.0 which guarantees no way to download them from your keyboard\mouse.

I want a property to be on the macro variable that makes it so SAS knows the macro variable should not be printed versus using a different method of calling the macro variable. This may not be possible as macro variables are plain text with no real inherent properties.

Not really. Having the encrypted password in the log does not make it secure.You are corect that one does not know the password, but they don't need to know the password in order to get into the system.

Internally we lock our databases down to protect PHI and Employee PHI. Having the encrypted password go into a log means someone without access to EPHI can use that login/encrypted password to see EPHI. This user would be internal to the company with access to every system.

I've run into some programs that don't let me copy-paste text into them. This is a problem, as I use a password manager (KeePass), and not being able to copy-paste my password into the login screen (as is the case with Minecraft) is a problem.

I could bypass this by using shorter passwords that are easy to type, but I'd rather ask you fine people if you know any software that "pastes" text by, say, issuing the key presses as a macro command. For example, pasting "agiK" would execute a-g-i-holdshift-k-releaseshift as key presses.

Explanation: The macro uses the InputBox method of the Application object. If the users clicks Cancel, this method returns False and nothing happens (InputBox disappears). Only when the user knows the password ("easy" again), the secret code will be executed. If the entered password is incorrect, a MsgBox is displayed. Note that the user cannot take a look at the password in the Visual Basic Editor because the project is protected from being viewed.

Can someone guide me with this problem. I am new to programming.

Programming esp8266 with ubidots.

I am trying to compile but I get an error on wifi password (macro names must be identifiers)

I have added notes to help.

Please use code tags when you post code or warning/error messages. To do this, click the button on the forum toolbar, then paste the text you want to be in the code tags. Finally, move the cursor out of the code tags before adding any additional text you don't want to be in the code tags. If your browser doesn't show the posting toolbar, then you can manually add the code tags like this:

[code]``[color=blue]// your code is here[/color]``[/code]

The reason for doing this is that, without code tags, the forum software can interpret parts of your code as markup, leading to confusion, wasted time, and a reduced chance for you to get help with your problem. This will also make it easier for us to read your code and to copy it to the IDE or editor.

I agree with gfvalvo's advice to avoid unnecessary use of macros. However, it is still useful to understand how to correctly use macros. For that reason, I recommend that you study the documentation provided in the Arduino Language reference:

Access Policy Manager supplies an OTP Generate access policy item that generates a one-time time-sensitive password and an OTP Verify item that verifies that a user entered the correct password before that password expired. In between the two actions, you must configure an action that delivers the one-time password to the user. To send the password in an email message, use the Email access policy item. You must have an external SMTP server and you must create an SNMP server configuration for it on the BIG-IP system.

A macro template to configure OTP over email is available for use in an access policy. Look at the macro, AD auth query OTP by email and resources, from the visual policy editor to determine whether to use it to help you configure the access policy more quickly.

Access Policy Manager supplies an OTP Generate action that generates a one-time time-sensitive password and an OTP Verify action that verifies that a user entered the correct password before it expired. In between the two actions, you must configure an action that delivers the one-time password to the user. To send the password in a text message, you can use a form-based HTTP authentication agent (if you do not want to use an Email agent). You pass the one-time password in hidden parameters to a form action. You must create a form action that sends the OTP using an external SMS.

A macro template to configure an OTP and use the HTTP Auth agent to deliver it is available for use in an access policy. Look at the macro, AD query auth OTP by HTTP and resources, from the visual policy editor to determine whether to use it to help you configure the access policy more quickly.

I feel so frustrated every time to login to the Tandem machine using

Win6530. Because there is certain time our for that session. I dont

know where it is configured. After every 3 or 5 minutes, the tacl

session automatically gets logged off. Again I have to again login

with my credentials.(which is not easy to type fast which has all the

combinations)So, i am looking for a macro which automatically lets us login to the

Tandem machine, whenever we start our emulator. I am using here

Win6530.

Or else, is there any way to set infinite timeout for a session. I am

not sure, whether or not the timeout is from the emulator or from

Tandem.Waiting for your valuable replies.Thanks,

bandi

3a8082e126