password

Hi, I want to set one of my sheet to be non visible. I have set its properities to xlsheetveryhidden, but project protection by password does not work. It will be enough when I add any (even blank) sub inside?

I have a protected file that has its column names in B6:K6 and data below. It is protected with the password "secret password". When the user hits a button, I have code that unlocks the sheet like so... Worksheets("MyOutput").Unprotect "secret password" My code then does its business, and...

The link below shows various ways to detect internet connection. Sometimes you have a requirement to enter a user name and password to access the Internet, how do I check if I'm fully connected to the Internet...

Hello, Using VBA I need to open a zip file where the excel file is password protected and save it on a designated location. I am able to open the file but the issue right now is, each time I run the macro, I am being asked (via pop-op window) to locate the file and than once the file is...

Hi experts, I have a long list of data exported into excel from a text file. This file contains output of a command from multiple network elements. Whenever there is a text string 'Welcome to', the below mentioned text should be copied to a new column till the next 'Welcome to' appears. In this...

I'm trying to get tables from a website which is password protected by username and password. It uses the classical web form with a "post" command to access to all the information so I cannot use Basic authentication. I've look in internet for a solution without success. Can anyone help me?

Hello, i had a excel which was protect with password and right now i forget the password, so there is any option to open that particular file. that excel file is a Macro-Enable file. Thanks in advance Amit Kumar

There are multiple pdf files in a folder. Please help me with VBA code which will loop through all the PDF file and save with a password. I have Acrobat distiller installed in my system.

Hi, I currently use the following code to lock a sheet in a Workbook: mysheet = "Sheet1"If ActiveSheet.Name = mysheet Then ActiveSheet.Visible = False Response = InputBox("Enter password to view sheet") If Response = "Sheet1" Then Sheets(mysheet).Visible = True...

Hi, i need vba code to unhide range of rows with password in one sheet and rehide after closing the workbook. thanks,

Hi I have an .xlsm file that is password protected through SaveAs-->General Options as the file is always opened read only without the password. I want to apply a macro to a button that will export a copy either the current worksheet, or the entire workbook to a specific location of H:/ the...

DOES ANYONE KNOW WHY WHEN I RUN THIS MACRO IT JUST PROTECT THE WORKSHEET BUT EVEN IF THE PASSWORD IS "1515" IT JUST SKIP IT AND SET IT TO NOTHING, SO WHEN I MANUALLY UNPROTECT THE SHEET IT JUST UNPROTECT WITHOUT ASKING ME FOR THE PASSWORD. Sub LOCKD() 'ActiveSheet.Select I try with this and...

HI All, Trying to design a Macro which will automatically unlock the workbook and do hide or unhide a Worksheet. What will trigger the Macro will be a value change in a cell. The problem is, the password is not constant. One week it will be one word and the next it will be something else. I...

Hi, I have a excel sheet that is used to calculate staff hours and the sheet is protected with a password to stop people changing it. It has checkboxes and fields which add up/minus etc depending on what is chosen, something that has taken awhile to produce and something I am proud of. I've got...

Hi All, I am attempting to create a spreadsheet and would like to know if it is possible if somebody selects "yes" from a drop menu options of "yes/no" that the row is automatically copied from one worksheet to another that is password protected? I want the first sheet to accumulate the workflow...

Hi All, I have a spreadsheet and would like to know if it is possible if somebody selects "yes" from adrop menu options of "yes/no" that the row is atomatically copied from one sheet to another that is password protected? I want the first sheet to accumulate the workflow coming into my team but...

I have about 90 worksheets in my workbook. About 75 contain sensitive financial information that I don't want available when someone is sent the file. Is there a way to "group" the 75 sensitive worksheets so that with one click of a Macro button, all 75 worksheets are hidden with a password...

hi, if anyone could explain why this is happening i would be very grateful I have a hidden sheet 'Exp' that is password protected, and automatically hides (veryhidden) when the user navigates away from it. This all works fine. The incorrect password message works too. But I am getting this...

Re: Hiding password characters Hi everyone, I am using code to produce a password box on opening a workbook, so far so good it works fine my only problem is that it shows the password it does not hide the chatacters using an astrix " * " please see code below any help to just add some code to...

We have a spreadsheet which has ranges that are password protected (i.e. using AllowEditRanges with a password). This is not because we don't want users to be allowed to ever change those cells, but rather it is to prevent them from changing them accidentally. Users are provided with the...