password entry

I'm working on a excel document that will be shared on an internal network and I want it to rely on another file for the key. Example: My co-workers and myself can work on this excel document on our internal network, but if someone takes the excel file without the "key" then the document will...

Hi guys, Not sure where to start with this one, any help is greatly appreciated. I am after a code that would run as soon as the workbook is opened. I would like it to first check the "Device name" and compare it to a list of names in the code which are allowed to open the workbook. If the...

Hi All I use a 3rd party add-in in Excel and every time I start Excel, I have to manually add the password etc. I tried recording the process but the macro recorder does not recognise the login pop up. Is there any way I can do this so I can create a shortcut button that will launch the add-in...

First of all, thanks for taking the time to read and consider this question! I am very new to using VBA in Excel, and am feeling my way around the language. I have come across a situation in which I am not sure how to approach the problem for a solution. Scenario part 1: I have timesheets...

Hi! I'm using Excel 2010 (Windows 7) to develop a workbook with the goal of tying conditionally visible worksheets to a case statement. Conceptually, I want a user to enter a password and click on the enter password button, and have the sheets they are authorized to see appear in the tabs...

i have some code for opening the workbook that only allows it to be opened if the correct name is entered. would i then be able to have an individual password for each user after entering their name. if entry is wrong i would like the workbook to close. the code i have is below x =...

thanks for looking at my post. I would like to create some code that when my workbook "MasterArchive" is closed that the password"Secret" for sheet"CuttingList" is put in place. Arguments=the password may already be set and if so the code would end, but if the password has not been set for the...

I am trying to utilize <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to access a device on a local network...

I am trying to utilize VBA to access a device on a local network and retrieve data from it's browser based output display. I have read threads on how to use VBA to fill out forms on a web page (e.g. User Name & Password). I am stuck because my situation does not involve a form on the web page I...