Require Password To View Column

Oct 17, 2008

I would like the user to enter a password to unhide a column. I am aware of how to use a password to unhide a worksheet, but now I would like just a column.

View 9 Replies


ADVERTISEMENT

Require Password To Unhide Certain Sheets?

Mar 14, 2014

I have a file with the following sheets: P1, P2, P3, Inventory. This file is sent to different people (users Ab, Ad, An) and P1-P3 sheets are set as "VeryHidden" because we want to avoid for example that user "Ab" can see or unhide certain sheets.

I'm wondering if it's possible to request a password when opening the document then unhide certain sheets according with that password, there will be 3-6 users.

View 2 Replies View Related

Require Password To Open If Username Does Not Match A List

Aug 8, 2014

I have a spreadsheet (don't we all) that is currently password protected - you double click the file and need to input a password before it will open.

I have some code that will protect a workbook from changes and only unlock for specific usernames, and i wonder if there is some code that will do the following:

-User opens spreadsheet
-VBA looks at the username trying to open the sheet, for this example the username is Paul.Smith
-Paul.Smith is not one of the people who should have regular access to this sheet - so the VBA requests a password from him prior to opening the sheet.

My username opens the same sheet (galvin.paddy), VBA see's that my name is one of the 'Authorised Users', removes the password and opens the sheet for me ready for use.

View 14 Replies View Related

Password Required To View Sheets

Oct 11, 2007

I have a spreadsheet which is used for STAT purposes at work, there are 14 users who use this spreadsheet.

The sheets are named after a user, i.e my sheet is under 'Steve'.

The problem I have is, I have a sheet thats unhidden on the spreadsheet (the rest are all hidden)

What i want is a form to open and request a username and password, or to gain the user name from there windows logon.

After the spreadsheet has recoginsed whom is entering the sheet, i want the spreadsheet to display there individual sheet, and keep everyone elses hidden.

I don't want them to have access to any sheet other than there own.

I then want an administrator logon, where that person can see all sheets.

View 9 Replies View Related

Password Login To View Sheets

Mar 13, 2008

I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:

Option Explicit
Const sName1 As String = "Lisa"
Const sName2 As String = "Philip"
Const sPw1 As String = "update"

Dim sPW As String, sUser As String
Dim sMsg As String, sTitle As String, sStyle As String
Dim iCounta As Integer
Private Sub cmbValidate_Click()
sTitle = "Incorrect Password"...........

View 5 Replies View Related

How To Fill Multi-Column List View

Nov 9, 2013

How to fill a multi-column ListView? I can get the first column, but not the second.

View 1 Replies View Related

Row / Column Header Not Fully Shown In Normal View

Mar 10, 2009

Recently I come across a file with only 1 sheet, in which is a table only occupied an array of A1:Q49. In Normal View I can see the row / column header of A-Q and 1-49 as usual, but nothing outside that range (only grey colour). Also, the empty cells outside A1:Q49 are all grey too. How can I do that?

View 2 Replies View Related

How To Require Cell Entry

Jan 3, 2010

I want to require cell entry by users. For example, if a user wants to entry information in cell C1, they must first enter information in cell A1 and cell A2. If there is no information in both of those cells, I want to display an error message to the user indicating they need to first enter information in those two cells.

View 10 Replies View Related

Excel 2007 :: How To Adjust Protected View Settings But Protected View Tab Is Missing From Trust Centre Settings

Dec 12, 2013

Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.

View 3 Replies View Related

Require Entry In User Form

Jan 19, 2009

I want to require that certain Text Boxes in a User Form have entries and I am coding the message box improperly.

View 7 Replies View Related

Require 6 Digits In UserForm Textbox?

Mar 6, 2012

I have many textboxes on a UserForm and the value entered must be 6 numeric digits, how can I do this in my code? I understand how to limit with code to numeric numbers in the Exit event but can't find how to REQUIRE all 6 digits be entered.

View 2 Replies View Related

Require Count On Basis Of Condition

May 8, 2012

I have data like

col A col B col C col D
DLM2.2 kWDLM75 kWDLM55 kWDLM160 kWDLM11 kWDLM1.5 kWRDLM110 kWRDLM2.2 kWRDLM11 kWRDLM55 kWDLM11 kWDLM30 kWDLM45 kWDLM1.5 kWUS40 kVAUS10 kVAFD45 kVAFD45 kVAFD6.4 kVAFD25 kVAFD45 kVAFD11 kVAFD11 kVAFD150 kVAFD10 kVAFD18.5 kVAFD25 kVAFD18.5 kVA

The problem is col B having M type and col C contain their respective ratings. I want summary report.

Rating 2.2 should give me total count, but if you see there are types.

In col A -
DL
RDL
blank cells

so, 2.2 DL = the perticular count
2.2 RDL = the perticular count

Only M type having subtype DL and RDL.

Im col B, there another subtype also like US or FD. For that also particular rating show their exact count.

Is that possible? I want excel formula not vba code.

View 7 Replies View Related

Require Maximum Number Value Containing Text?

Jul 12, 2013

I've got a table where I want excel to generate the next number. With the following table excel must generate an invoice number (column B). I've got the formula to work correctly until a payment is done as shown in B12,B13 and B14. I need a formula to lookup the maximum invoice number (SC1-0007) and in cell B15 the serial number SC1-0008 must be shown. [URL]

View 1 Replies View Related

VBA Formula That Require Control+Shift+Enter

May 26, 2009

VBA automation -
Excel added the formula - but they all return "Not Found". After the VBA automation - I visit each cell, see the formula is correct and then press Control +Shift + Enter; then the correct value displays! Of course, the curly brackets also appear in the formula bar. In VBA I tried to use the:

objXL.ActiveCell.FormulaArray = "=IF(ISERROR(INDEX(PositionDataSell!$T$2:$T$505,MATCH(" & lngContractID & "&" & strQuote & strConCat .....
The Excel Formula bar for the cell is just empty (blank)

Using only the Formula property:
objXL.ActiveCell.Formula = "=IF(ISERROR(INDEX(PositionDataSell!$T$2:$T$505,MATCH(" & lngContractID & "&" & strQuote & strConCat .....

The correct formula is created in each cell, but. Until I visit that cell and use the Control+Shift+Enter - the lookup will not work. It is proof that the right formula is there, without the curly brakcets.

In Excel - my vba code successfully constructs these formulas: In essence: It checks for an error and prints "Not Found" if no match is found in the check. It test for two values in a row - matches them to two columns on a row in another worksheet, and returns a third value for the matches of the same row.

View 5 Replies View Related

Linking Cells That Require Sorting, Between Worksheets

Mar 8, 2008

I’m having problems linking data from various worksheets to one master worksheet, all in the same workbook. The workbook contains swimmers PB’s (personal best times) for each stroke and after each gala the swimmers new time is entered onto the worksheet. The worksheet data is then sorted so that the fastest swimmer is at the top.

The master worksheet contains all swimmers by name (alphabetically) and their best times for each stroke, what I am trying to do is have the master worksheet update automatically when I enter the swimmers new PB’s in the individual stroke worksheets, this works when I use ’Paste Special’, but when I go to sort the data with the fastest swimmer at the top, the data in the master worksheet does not reflect the correct times.

View 9 Replies View Related

Require 2 Numbers Before A Decimal In Data Validation?

Feb 16, 2012

How can I require 2 numbers before a decimal in data validation? I have a formula to require at least to characters after.

I'd like to require the user to enter at least ##.##

View 9 Replies View Related

Macro While Running Require One Form Initialization

Mar 6, 2012

I am using one macro in order to format the huge data and approx. it would take 2 to 3 min to complete the task.

While running this macro there will be more then 10 different sheets will open and close because it takes data from different sheets.

I can use Application.ScreenUpdating = False in order to hide this but along with this user should get initialization tab (we can see while installing any application).

View 7 Replies View Related

Userform Textbox Require Number Greater Than 100?

Jul 4, 2014

I want to require the user of my Excel Userform to input a number greater than 100. How do I do that?

View 4 Replies View Related

Require Training Matrix From A Report List

Nov 20, 2008

I have a report of users and thier roles

User# User_Christian User_Surname Role
1 bob smith operator
1 bob smith supervisor
1 bob smith warehouseman
2 john stone operator
2 john stone gunman
5 george brown Foreman

What Im after is:-
a matrix with unique Role list across the top
Unique ID & Name down the side
(I can do all the above using recorded macro's)
but the clever bit I cant even start to work out is how do I get matrix populated from the list?

View 10 Replies View Related

Unhide A Column With A Password

Feb 20, 2010

I have column B hidden as it holds information that only certain people should be able to see.

I have a button in column A which when pressed, I would like the following...

1- a prompt box to ask for a password

2-once the password is entered, Column B unhides.

3-once an entry in Column B has been made, it automatically hides again.

View 9 Replies View Related

View Range In A Column And Add Answers Of That Range In Different Column

Jul 17, 2014

How to write a forumula that can view a range in column A but select the answers of that range in column B and add them together?

For example my spreadsheet shows:

Column A Column B
1.1 5
1.5 2
1.7 9
1.8 6
2.1 2
2.5 5

So in the example above what I need the forumla to do is look at range of 1.10 to 1.19 in Column A and add the answers of that range in Column B, which would equal 22 (5+2+9+6).

View 4 Replies View Related

Writing To File May Require Special Print Statement Syntax

Jan 22, 2013

Code:
' write data to txt file
For j = 1 To 3
For k = 1 To 21
Print FNum, OPTOarray(j, k)
Next k
Next j

I am writing an Array to a text file but I keep getting an error that the Print statement requires a suitable object. I tried Debug but all this did was put the data into the immediate window and created a file that was empty.

"????.Print FNum, OPTOarray(j, k)".

The data in the immediate window is correct but when you open the text file with notepad there is nothing to be seen.

View 1 Replies View Related

Password Lock Hidden Column / Row

Feb 22, 2008

Is there a way to lock a column hidden so that it can't be unhidden? Maybe with a password? I tried saving the file with a password but I could still go in and "unhide" that column.

View 3 Replies View Related

Excel 2007 :: Hide And Password Protect Column?

Jun 26, 2012

I have an intern that is working with me, and I have a file that I need updated but one of the columns has confidential information so I would like to just hide & password protect this column this way he can't access/view this information but still have access to modify the rest of the spreadsheet.

Is there a way to do this in Excel 2007?

View 3 Replies View Related

Multiple Password Protection For A Column Based On Text Entered

May 29, 2014

Is it possible to have multiple passwords for a column based on text entered. I was hoping to use it as a form of digital signature. Eg if I wanted to enter my initals KP I would have to enter password assigned to KP, if a staff member entered their initials "AB" they would have to enter password assigned to that.

View 1 Replies View Related

Password Protection :: Asking For Password Of An Old Deleted File

May 27, 2009

When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.

View 11 Replies View Related

Forgotten Password For Password Protected Sheet

Mar 21, 2007

I have a spreadsheet, which has certain worksheets that are password protected. I need to make changes to some of the formulas, and the VBA modules, however I cannot remember the password!! Is there a way of identifying the password??

View 3 Replies View Related

Macro - Paste Password Into Password Box

Nov 28, 2008

I am havng problems with the belwo macro code -

Range("G7").Select
Selection.Copy
Workbooks.Open Filename:= _
"Q:PublicPAYMENTS Q&RREPORTSSuspense Activity BUSINESS2008 - Suspense BUSINESS - Activity Reports2008 Avon.xls"
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub

When i open the workbook it requires me to insert a password, i tried to type this but excel will not follow keystrokes, i then inserted the password in cell G7 which i then copy and paste, which you can see the copy at the beginning of the macro.

Is there a way where you can get it to insert the password so i can open the workbook in a macro.

What im trying to do is save 26 suspense spreadsheets by just clicking on a macro.

View 9 Replies View Related

Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?

Jan 12, 2007

I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub

View 3 Replies View Related

VBA Code To Require Fields - Temporarily Save File Email It Then Delete Temp File

Apr 9, 2014

I have a spreadsheet where I want to require certain fields to be completed then I want to have that file auto emailed. I have learned that I do need to have the file saved before sending otherwise the data will not appear in the email, so with this I want to have the file temporarily saved emailed then the temp file deleted.

Here is the code I have so far but it errors on the blue text, I did change the TempFileName from = "Copy of " & wb1.Name & " " & Format(Now, "dd-mmm-yy h-mm-ss") to = [C16] & "_" & [B6] & "_" & [D6]

Private Sub CommandButton1_Click()
If Range("B6").Value = "" Or _
Range("d6").Value = "" Or _
Range("f6").Value = "" Or _
Range("E9").Value = "" Or _

[Code] ......

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved