Password Lock Hidden Column / Row
Feb 22, 2008Is 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
ADVERTISEMENT
How To Lock Each Tab With Different Password
Oct 25, 2011I have a excel document with 5 tabs (sheets) and, because different people work with a different tab (sheet), I want to lock each tab (sheet). I want the tab to be visible on the tab bar but when you click on it you will not be able to see the content of that tab (sheet) until you provide the right password (each tab with a different pasword).
View 2 Replies View RelatedLock Rows Unless They Are Hidden Or Unhidden By Macros?
Jul 15, 2014The small attached "Demo2" file indicates my problem. In the "Scorecard" sheet I'm using macros driven from listbox menus to hide or unhide rows on the "Tasks" sheet. It is VITAL that the rows on the "Tasks" sheet not be deleted or have new rows inserted. But, if I Protect them then the list box macros won't function. Is there a macro that will allow these macros to hide or unhide rows without allowing a user to add or delete these rows in the "Tasks" sheet? If possible a simple "global" solution is preferred as I have 100+ If/Then entries to contend with...
Attached File : DEMO2.xlsm
Creating A Macro To Lock A Password Protected Sheet
Feb 23, 2007I've got a work book with numourous password protected sheets which i quite often have to update (as i use around 10 of these with at least 10 sheets in each its time consuming). I've had several goes at creating 2 macros to unlock and then lock the sheets (with my password). I've managed to create on that unlocks the sheets using the password but i can't get a macro to lock the sheets up again using the password.
View 9 Replies View RelatedDifferent Password To Unhide The Hidden Sheets.
Nov 22, 2008I have 5 sheets, 3 of them are hidden, how can i put a 3 different password to unhide the hidden sheets.
View 6 Replies View RelatedCan You Password Protect Hidden Cells?
Aug 19, 2009I was wondering if it was possible to hide cells using protect sheet? I have a worksheet that contains confidential data and would like it so the cells appeared blank unless you had the password. I know you can hide rows and columns but I need everything on the sheet to be hidden.
View 2 Replies View RelatedPassword Protect Hidden Sheet?
Feb 28, 2013Is it possible to have a hidden sheet password protected, so that only I can unhide the sheet ?
View 1 Replies View RelatedPassword Protecting Hidden Sheets
Jul 25, 2007I am using some VBA I found here to password protect a hidden sheet. It works perfectly for 1 sheet, but I am trying to hide 6 but am having problems. Under the HideSheets part I've modified it fine, by using
Sub HideSheets()
'Set worksheet to Very Hidden so that it can only be unhidden by a macro
Worksheets("Confidential1").Visible = xlSheetVeryHidden
Worksheets("Confidential2").Visible = xlSheetVeryHidden
Worksheets("Confidential3").Visible = xlSheetVeryHidden
End Sub.........
Lock Cells, Protect Sheet With Password & Time Stamp
Jul 18, 2007I have a worksheet with employees names and their overtime hours worked that week. I would like to add some code to a button that will prompt for a password. If that password matches a predefiened password then lock a range of cells and place a time stamp next to the button and maybe change the button color of the button to Red. Now if the person with the password wants to change the locked cells, they can click the button again and enter the password and the button will turn green so they can make the changes. I would like the time stamp to be updated every time the cells are locked. Also wanted to have one button for every work week so about four buttons per worksheet. Here is an example of the worksheet. The range of cells I want to lock are the ones in bold.
View 3 Replies View RelatedAssign Password To A Hidden Sheet, Only 1 Cell Populated
Dec 11, 2006This is my input for password prompt:
Sub CommandButton1_Click()
Dim wSheet As Worksheet
On Error GoTo ErrHandler
Currently, my excel is protected with a password "PSWD" when users open the file. In my vba script, I have a function that can unprotect my excel without any password input box to the users. This method is to unprotect the file and allow users to do any formating columns and rows tasks, such as add or delete cells. After users finish their job, the file will be protected back. The function is such as below:
Dim wSheet As Worksheet
For Each wSheet In Worksheets
Application.ScreenUpdating = False
If wSheet.ProtectContents = True Then
wSheet.Unprotect Password:="PSWD"
Else
My questions are:
1. How I can create a hidden sheet that has one cell populated only?
2. How can I assign the password that the user enters at the "TextBox1" (first code) to a cell of of the hidden sheet? Do I have to modify the first code?
3. For the second code, how am I going to assign the value to at the wSheet.Unprotect/Protect Password:="..." with whatever the user has previously chosen as a password that refers at the hidden sheet?
Opening Password Protected/hidden Worksheets By The Manager
Oct 4, 2007I've looked through this wonderful sight and haven't found one close to my project. I am a bit rusty on VB programming. I am working on workbook that contains multiple worksheets. Each worksheet is hidden and is accessible with a login and password so that only a specific user can access. My question is: How do I modify this so that the manager can open the workbook and view ALL worksheets without having to enter the login name and password for all of his users? Any help would be great. Thank you!!
Below is what I have so far: ....
Username And Password Form - When File Is Saved By Any Users All Hidden Files Get Unhidden?
Mar 23, 2014I have Excel Sheet that open with user name and password.
Like if it's open my Admin - he can view all Sheets
If open by any user - it opens only users sheet.
Problem is once file is saved by any users, all hidden files get unhidden and Admin Sheet is open.
Requirement: if User1 saves file other sheets should not get unhidden.
Column Fill Colors In A Column Chart When Some Columns Are Hidden
Jul 13, 2014When I hide columns in a column chart the different fill colors I used on specific columns no longer show up with the colors I originally had. Is there a way to maintain the proper sequence of column fill colors even when some columns are hidden?
View 1 Replies View RelatedHow To Lock Formula Column
Oct 28, 2013How to lock a formula column that need a password in editing the formula
View 3 Replies View RelatedLock Column Cells In Table
Mar 27, 2014I want to copy a formula and want to lock a certain column, just like you use the dollar signs in normal formulas. Because the data in tables can't be locked with dollar signs.
Example:
example 1.xlsx
Lock Column Header So That It Will Always Stay At Top?
Jan 28, 2013How do I lock a column header so that it will always stay at the top as I scroll down the page?
View 4 Replies View RelatedLock Column Auto Sort
Jul 6, 2013is there any way to automatically sort a column from A-Z without need to choose column, sort&filter, a->z? maybe a pivot table?
View 1 Replies View RelatedLock Column F In Every Sheet Having Formula
Nov 27, 2011I have Book having 11 Tables.
In each Tables in Column F i have formula like., =INDEX(Sheet2!A:A,MATCH(Jyotindra!G10,Sheet2!B:B,0))
I want to lock only column F for all Tables. and hide formula
All other columns and cell should be free to excess or edit.
How can i do that for all sheet at once?
Lock In A Title On Column Allowing Sorting
Jan 29, 2009I am trying to create titles for columns. I can do that by just creating them in the cells above the data. The problem is that the titles sort into the data using the sorting feature. When I lock any cells and protect them, the sorting is locked out. Can I use some sort of header over the columns that remains in place where I can still sort the data below, by clicking on the column and sorting?
View 3 Replies View RelatedSheet Protection Column Width Lock
Jan 16, 2014I am trying to Protect a Sheet to lock the width of just one column. Does the lock apply to all the columns in the worksheet or can it apply to a single column only. I can't seem to get this to lock just one column-if it is possible.
View 1 Replies View RelatedLock Cells Based On Entry In Other Column
Mar 30, 2007I have a spreadsheet where there are two columns for the user to enter data in, but they can only select one column. I want to lock the second cell if data is entered in the first. I can't find a way from validation to do this. Is there another way via VBA (stupid question, I know... VBA does everything but scratch your butt)
View 4 Replies View RelatedColumn Hidden At All Times
Jan 22, 2010is there a code to hide specific columns that i dont really need. i dont want to delete them, just hide them. even if i try to unhide them manualy from Format- Unhide they dont unhide. These columns stay hidden at all time.
View 2 Replies View RelatedFormat All Cells In All Sheets To Protection Hidden On Visible And Hidden Tabs
Feb 28, 2014I am trying to format all cells on all sheets (hidden or otherwise) as "Locked" so when the sheets are protected the user can't see the formulas. This macro individually selects every sheet in the book and applys the formatting. Is there a way to modify this code to accomplish the same thing without having it actually select every sheet? The only reason it is an issue is that after running the macro you end up on the last sheet in the book.
View 7 Replies View RelatedTaking Sum Of Column When Some Rows Hidden?
Feb 29, 2012I have autofiltered a column to meet a certain criteria (which hides some of the rows), then I want to put a cell with the sum at the bottom of that column. When I do this, it takes the sum of all of the rows in that column, even the rows that are hidden. Is there a way to only take the sum of the rows showing?
View 5 Replies View RelatedLast Cell Used In Column When Rows Are Hidden
Apr 14, 20071. find the last cell used in a column when the rows that contain the data are hidden. I tried using Range("A65536").End(xlup).Select. but when the rows are hidden it doesn't give me the last cell used.
2. I am trying to restrict my search to just one row. When I try using the cells.find function it looks for the whole sheet but I just want it to search for some particular data in just one row or a specified range.
Sum Contents From Column Without Including Hidden Rows
Apr 13, 2007Which formula should I use if I want to sum a column without including content from hide rows in the same column.
a2 is hided so I need the sum = 6
1
9
1
2
2
How To Skip Hidden Column Cell Value Count
Jul 15, 2014I have few column values to count. I don't want the hidden column value. In that formula the hidden value also counted. How to ignore that hidden column value count, using macro/formula.
eg:
col A - col B - col C - col D - col E - col F
Task -- ok1 -- ok2 -- no1 --- ok3 -- ok4
Col D should be hidden. Final count result should be: OK = 4; No=0
Column Numbers To Adjust When Rows Are Hidden
Feb 12, 2014I have multiple tables that populate with data based on a combination of metrics that are tied to various dropdown menus. Whenever a combination of metrics yields a row without a value in at least one cell, then that row is automatically hidden. My problem is that while the rows are hidden, the column number's don't adjust. For example, if row 3 is hidden in a table with 5 rows, then the column numbers appear as 1, 2, 4, 5 (the table will shift from 5 rows to 4).
View 1 Replies View RelatedFilter A Dataset Using The Criteria In A Hidden Column
Oct 23, 2007IS there a way to filter a dataset using the criteria in a hidden column? Auto-Filter will not allow this, and Advanced Filter is not user-friendly for the end-user of this file.
View 2 Replies View RelatedChange Active Cell Value In Hidden Column
Apr 11, 2007The attached sample workbook has a listbox of areas in a userform. The Textbox on the user form is so that the user can edit the Area names in the listbox. The userform functions fine as long as the column that contains the area name is not hidden. What I want to be able to do is edit the Area Names using the Textbox with the area name column hidden.
View 2 Replies View Related