Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Password Box To Show Automatically


I have protected a few hidden columnx in my worksheet and have sent it to my client who has the password.

He had a complain. Every time he wants to unhide the columns, he gets an alert to unprotect the workbook. The process of going to the Review tab and pressing the unprotect tab is what he finds annoying. My questions is the following; Is there any way that the password box immediately appears once he attempts to unhide the columns?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Macro - Paste Password Into Password Box
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 Replies!   View Related
Automatically Enter Password
I have recently written some programming in a spreadsheet (1) which, on opening, opens up another spreadheet(2), ammends this spreadsheet(2), and then closes it before the user can start using the original one(1). This is done to monitor the usage. The information added into the atomatically opened spreadsheet(2) includes date and time of opening and the users id as well as adding 1 to counter cells. Both .xls files are located on the same server and I dont want people to catch on to the monitoring and if they do I dont want them to then go into this file(2) and remove their information.

If I password protect this file(2) it then promts to enter a password when it runs at the startup of the initial spreadsheet(1) which is no good as it would defeat the purpose if the user knew the password. Is it possible to add a few lines into the code (see below) after it initiates the opening of the usage file?

Private Sub workbook_open()
Application. ScreenUpdating = False
Workbooks.Open Filename:= _
"S:Newman CommonCATEGORY MANAGEMENT - RangesEPoS Usage.xls"
Dim Counter As Integer
Counter = Cells(2, 7)
Counter = Counter + 1
Cells(2, 7) = Counter
Cells(Rows.Count, "BV").End(xlUp).Offset(1, 0) = Now
Cells(Rows.Count, "BW").End(xlUp).Offset(1, 0) = Application.UserName
ActiveWorkbook.Save
ActiveWindow.Close
Application.ScreenUpdating = True
End Sub

View Replies!   View Related
Type Password, Show Letters As Asterix's
I have a password protected form in access (I know this is excel but the code is the same), and when i click on the button and the inputbox opens for my password, i don't want it to display what i am typing, instead i would prefer asterix's?

View Replies!   View Related
Password / Permissions On A Dropdown Box
Hi there, I have searched for this problem and whilst I can see several "round-about" ways to achieve what I want, none quite do it in a way I would like.

Essentially, I have a dropdown box, with a list of water types. What is selected from the dropdown determines the data from a lookup table that gets utilised in subsequent calculations.

The lookup table is protected and cannot be edited, however what I would like to do is for the last entry on the dropdown box, which could be called "special water" would then prompt for a password. If the correct password is entered than the last row of data corresponding to "special water" in the lookup, becomes unlocked and can be edited. If the password is not forthcoming the user cannot select special water and consequently cannot edit the corresponding row in the lookup.

I can think of a few long-winded ways to achieve the basic result, but nothing seems elegant....or fool proof

I had thought about a simple check box against the appropriate row in the lookup called "unlock" which would require a password to use. Once the password is entered, then it can remain open until the check box is clicked again whereby a password is required to "lock" it again

I should add that I use 2003.

View Replies!   View Related
Input Box Prompt For Password
How The Vba Code Used For

My Excel File Name "eai.xls" ,when I Click The File , It Open The Sheet Name "menu" With The Inputbox Prompt:="put Your Id"
When The User Put The True Id , It Will Show The Input Box Prompt:="your Password" . If The Password True Will Activate The Sheet Name "data" .and Hide All The Menu Bar.

If The Wrong Id Name Show The Msg.box "re Enter Your True Id " ,that Also For The Wrong Password In Which If User Put More Than 3 Times Wrong , Will Close The Workbook And Exit File.

The User Persons Allow 10 Person Id . Keep In The Table Of The Sheet Name " Id And Password" The Id No. Are In The A1:a10
Password No. Are In B1:b10
This Sheet Name Is Hide And Protect

View Replies!   View Related
Password Char For An Input Box
Is it possible to set a PasswordChar for an InputBox?

Basically, I have an input box asking for an admin password to make changes, and I'd like to make it so onlookers wouldnt be able to see the password. Any suggestions on how to do this?

I could make another userform and have the textbox have a PasswordChar, but I'd rather not.

View Replies!   View Related
Password Box For Spreadsheet Open
I am just wondering if it is possible to insert a module or a code such that it is user specific.

In detail, there are two types of users: Administrator and User.

If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.

I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.

View Replies!   View Related
Change Open Workbook Password Box
I need to know weather it is possible to change the "Password protected workbook" box upon file open with a custom user form. I know you can because you can change and disable the "Save As" box etc. I dont mind using the code with a certificate to open the workbook but id prefer not to...


View Replies!   View Related
Password Dialog Box Appearing On Open
I have not asked for this Dialog Box, but it appears when I open the workbook.

I must have done some strange things - hope someone can give me a hint.

I have attaced a picture of the Dialog Box.

View Replies!   View Related
Automatically Show Every Hour
What other code than that shown below do i need to make my message box work,

"Module Code"
Sub MyMacro()

Application .OnTime TimeValue("00:00:00"), "MyMacro", ["23:00:00],
[TimeValue "01:00:00"=True]
MsgBox(BoMLogDue, vbOKOnly, BoMLogDue) As VbMsgBoxStyle

End Sub

"Workbook Code"
Private Sub Workbook_Open()
Application.OnTime TimeValue("00:00:00"), "MyMacro", ["23:00:00],
[TimeValue "01:00:00"=True]
End Sub

View Replies!   View Related
Automatically Show Range Address Of Selection
does excel have a function or some kind of method where you can have it display the range of cells that you have selected? For example, if I highlight cells A5:G7 what would be the code for excel to display "A5:G7" in a message box? I need this to be dynamic, so the next time I select cells B3:T32, it needs to display "B3:T32."

View Replies!   View Related
Hide & Show Sheets Automatically
I would like to be able to use the before save event to hide some sheets before the save then after unhide some sheets. So that the user carrys on with the sheets they had before saving but when the document is reopened the correct sheets are hidden.

This is what I have so far but unfortunately when you click close and then save changes it runs the before save code and then goes around in circles, reasking the user if they want to save changes

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim ws As Worksheet

Cancel = True
Application.EnableEvents = False
Sheets("Protected Content").Visible = True
For Each ws In Worksheets
If ws. Name <> "Protected Content" Then ws.Visible = False
Next ws
Me.Save
For Each ws In Worksheets
ws.Visible = True
Next ws
Sheets("Protected Content").Visible = False
Application.EnableEvents = True

End Sub

View Replies!   View Related
Automatically Hide/Show Rows Across Worksheets
When I call a series of subroutines from different worksheets, ScreenUpdating = False is not working.Here is my

Private Sub Worksheet_Change(ByVal Target As Range)
With Application
.Calculation = xlManual
.EnableEvents = False
End With
If ActiveCell = "No" Then
Call Sheet3.DisableTBs
Call Sheet4.DisableTBs
Call Sheet5.DisableTBs
Call Sheet6.DisableTBs
Call Sheet8.DisableTBs
Call Sheet9.DisableTBs
Call Sheet10.DisableTBs......................

View Replies!   View Related
Show Page Breaks Automatically When I Open A New File.
I want to make Excel show page breaks automatically when I open a new file. Please tell me how to do that. I tried changing the book.xlt and sheet.xlt files, but to no avail. I am using Excel 2003.

View Replies!   View Related
Automatically Hide / Show Rows Based On Cell Value
I wrote a small code to hide some columns if a certain cell is equal to a certain string.

The cell is actually a drop down list and when they select a certain one, I want it to hide 2 columns. So I wrote the code with sub name Action, but I want it to be running all the time. I tried to achieve this by writing the following code however it gave me error 438 for my 2nd line.

Sub Auto_Open()
Range("A1").OnEntry = "Action"
End Sub

Auto Merged Post Until 24 Hrs Passes;Oh, by the way error 438 states: Object doesn't support this property or method

View Replies!   View Related
Show Pictures With A Combo Box
Is it possible to show pictures with a combo box instead of using data validation list.

View Replies!   View Related
Show Text Box On Chart
I am trying to add the date my charts were created. I have the date the charts were created in a cell then I added a text box to each chart referencing the cell with the date. On some of the charts the date is showing. But on other charts on same sheet, the date only shows when selecting the chart area of the chart but disappears when selecting other charts or cells on the same sheet.

View Replies!   View Related
Automatically Expand Row Depth To Show Cell Content
I have a spreadsheet with a master front page, which basically copies the contents of other cells in other sheets for it's own content. ie:-

the formula in cell E16 on the master sheet is ='Sheet 7'!$B$16 (Please note that cell B16 is actually a merged range of B16 to H16)

Everything works fine until such time as the orginal cell contains an amount of text which is deeper than the cell on the master page eg cell B16 on sheet 7 is 330 pixels deep while the cell E16 in the master sheet is only 16 pixels deep.

What I would like to happen is for row 16 in the master sheet to expand in depth by whatever is requried to automatically show the full content of B16 on sheet 7.

View Replies!   View Related
Form First Only Show Input Box For EmpID
I need to create a form to update employee details.

The one I created has input boxes for all the details in the form. eg. Name, ID, DOJ, Address, etc. So once you enter all the details and press enter, the details gets updated in the database.

Now, what I want is, my form should first only show input box for EmpID. Once I give the input for EmpID and press enter, the form details should now change to Name. After updating the Name, it should show input box for DOJ.


View Replies!   View Related
Message Box Show Specific String
I need to refer the LAST ROW OF COLUMN "D" to appear in the message box for the below code along with " Receipt number" which is in Sheet2.

Sub saveit()
With Sheets(2)
r = .Range("B65536").End(xlUp).Row + 1
InvN = Cells(15, 4).Text

If Range("c18") = "" Or Range("c20") = "" Or Range("c20") = "" Or Range("c24") = "" Then
MsgBox "Please fill all required fields", vbCritical, " Missing data"

Exit Sub
End If...............................

View Replies!   View Related
Show The Name Of Opened Workbooks In The List Box
I want to show the name of opened workbooks in the list box, but the following code does not work.

for example, I opened 'a1.xls' and 'a2.xls'. The listbox of 'main.xls' should show their file name.

View Replies!   View Related
Show Message Box When Certain Value Entered Into Cell
This seems like a very simple question but I can't find the answer that I'm looking for. I have a spreadsheet with a drop-down ( validation) list. Based on what the person selects, I then would like to have a message box to come that would direct them that certain cells then need to be filled in.

View Replies!   View Related
Automatically Hide & Show Rows Based On COUNTIF Result
What i would like to do is Hide Rows Based on Cell Value in Multiple Sheets & Multiple Columns
and i need the macro to be fast

Sheet1
If the value in Range BE11:BE160 equals 1 don’t hide the row
If the value is “0” or “ “ then hide the row
Sheet2
If the value in Range BE11:BE160 equals 1 don’t hide the row
if the value is “0” or “ “ then hide the row
Sheet3
If the value in Range BE11:BE160 equals 1 don’t hide the row
if the value is “0” or “ “ then hide the row
Sheet4
If the value in Range O1:O150 equals 1 don’t hide the row
if the value is “0” or “ “ then hide the row
Sheet4
If the value in Range B1:B150 equals 1 don’t hide the row
if the value is “0” or “ “ then hide the row

View Replies!   View Related
Show Popup Box For X Seconds On Workbook Open
is there a way to put a time delay on a pop up box - like show a pop up box for like 2 seconds when the file is opened?

View Replies!   View Related
Show Move Or Copy Sheets Dialog Box
I press Shift and click on the selected sheet tabs, goto Edit> Move or Copy Sheets... the dialog box allows move or copy to a new workbook or to an open workbook. Macro doesn't record syntax for the Dialog box. This build-in function also doesnt allow me to selectively choose the worksheets in the active workbook.

I am looking for this code or a sample dialog box as I need to incorporate it as a part of my task automation macro. I would like a dialog box that allows eg. listbox to choose the individual sheets, then with option to Copy only (collectively Copy or Move are also fine) the selected sheets to a new Workbook or an already open Workbook. I am using Excel 2003.

View Replies!   View Related
UserForm Text Box To Show Range Data
I have created a User Form with required controls to add data in a worksheet and it works fine. Now, I want to retieve data from the hidden worksheet and to view the data in one or two text box controls by clicking a command button placed on the user form. I expect the user to use the user form only.

View Replies!   View Related
Efficient Entry Of Data & Automatically Have Their Price Show In Adjacent Cell
I own a Hair Salon which collates its daily takings using a spreadsheet. A section of this takings sheet asks staff to enter which Products have been sold and what they where sold for (RRP), so that once all products have been entered, totals at the end of the day allowing the end -of-day "till-up" process to reconcile purchases and services rendered aginst cash and cheques received.

Unfortunately there is over 600 products to choose from and this evergroes as new products are introduced by manufacturers. Names are long and often very similar, and product price manual listings are slow to reference, therefore the customer has to wait while the staff find the right product and select the right price.

All of this is subject to human error. What i would like is simply to enter part of the product name into a Cell and the right product to be visibly selectable and the price automatically added to an adjacent cell.

View Replies!   View Related
Code To Open Comments Box Automatically
Does anyone know code to bring up a comments box automatically when a certain word is entered into a cell? I have an If statement but I just don’t know how to open a comments box in the same cell.

View Replies!   View Related
Drop Down Box To Show 1st Instance Of Repeated Data
I have a list that I want to show in a drop down box. The list is like this;

MPK4
MPK4
MPK4
MPK4
MPK4
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
SPC600
WK-7
WK-7
WK-7
WK-7
WK-7
WK-7

Can a drop down box be made to only show each item 1 time?

View Replies!   View Related
Set Focus To Text Box Upon User Form Show
I have a TextBox and 2 Commandbuttons. I need the cursor to return to the TextBox when the Userform is loaded without the user selecting the TextBox.

View Replies!   View Related
Automatically Open Comment Box When Data Is Entered.
I have a spreadsheet where we calculate lost time of machinery and how much money is lost. Every day someone enters the hours that the machines were down and then enters comment in that cell stating what happened or what the resolve was. So for example Machine A runs 24 hours a day, but 12-19-08 it had mechanical issues and was down for 2 hours, so the entrant will enter 22 in that cell, then have to right click back in that cell, go to insert comment and enter "need to change belts." Then if he finds out later that they were down another two hours he would have to change the hours, right click in the cell and edit comment. What we have been coming across is that after awhile he just enters the hours and not the comment. Besides firing a lazy operator I would like to make it more user friendly and ensure that the data entry person is entering the comment.

I would like after the hours are entered in the cell for the comment box to automatically open. I figured there has to be a formula to do it, but i am not at an advanced level. Can you help me?

View Replies!   View Related
Vba Formula Automatically Inserts Into The MS Project Box
i'm using a macro in excel 2007 that will open a Microsoft Project file, and go to the filtering menu. This is working fine however i have come to a deadend as i need the answer from a Data validated menu to be inserted into a box that project creates. Basically i need to copy the text from my excel (worksheet 2, cell c2), into my vba formula so that it automatically inserts into the MS project box. I hope this all makes sense and would be massively gratefull if you could point me in the right direction.

View Replies!   View Related
Combo Box Dynamic Range Stops Updating Automatically
I could need a code for a Combo Box to selects the range in Column A. The range includes all non-blank cells.

View Replies!   View Related
Drop Down Box; Automatically Fill All The Information Into Address Column
I have inserted the sheet. As you can see in Sheet 1 I have the Store, Address, Town etc, I would like a drop down box in D13 ( Store Name ) so when I select a store it will automatically fill all the info into D15:D19 Address, Town etc. The info will be pulled from Sheet 2.

View Replies!   View Related
Combo Box Macro In Worksheet Doesn't Run Automatically
I have a combo box in a worksheet with a macro written for it that works fine but when I open the worksheet it doesn't run automatically, I have to find the macro and tell it to run.

How can I get it to run as soon as the worksheet is opened

Here is the code for the macro

Private Sub combobox()

ComboBox1.clear
ComboBox1.AddItem "Mit Rekuperator"
ComboBox1.AddItem "Ohne Rekuperator"

End Sub

Private Sub ComboBox1_Change()

Run "PinchInternHeatExchanger"
Select Case ComboBox1.Text
Case "Mit Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("L99")
Case "Ohne Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("E11")
End Select
Run "PinchPoint"
End Sub

View Replies!   View Related
Password Protection :: Asking For Password Of An Old Deleted File
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 Replies!   View Related
Forgotten Password For Password Protected Sheet
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 Replies!   View Related
Data Validation List Automatically Show The First Item In The List Rather Than Showing Blank
I can't seem to find a way to make a data validation list automatically show the first item in the list rather than showing blank.

View Replies!   View Related
Password Protect: Unlock The Worksheet, Autofilter It, Print It, Unfilter It, And Password Protect The Sheet Again?
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 Replies!   View Related
Macro: Show A Message Box Instead That Says "File Not Saved!"
I use the following macro to save my worksheet. However, if I click cancel when the save box is open, then I am presented with an error. How do I get it to skip the error and show a message box instead that says "File not Saved!".

View Replies!   View Related
Show Cell Value(text) In Comment Box Text, Or Mouse Tool Tip On An Gif Icon
I have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.

I've look the properties of this to objects and can figure it out.

View Replies!   View Related
Compare 2 Columns & Delete Rows Ouside Scope & Show Formula Result In Message Box
I have the following code to compare two columns and delete adjacent rows if 1 is greater than or equal the other...

Sub LastReceipt_GT_Confirmed()

Dim intLstRow As Integer

For intLstRow = Range("E" & Rows.Count).End(xlUp).Row To 2 Step -1
With Range("E" & intLstRow)
If .Value > .Offset(0, 1).Value Then .EntireRow.Delete
End With
Next intLstRow
For intLstRow = Range("E" & Rows.Count).End(xlUp).Row To 2 Step -1 .............


View Replies!   View Related
Hide The Sheets By Option Box & Check Box And Help For Creating The Message Box
I have attached my spreadsheet.
Problem no.1:- I want to make all the sheets hidden except Main Index sheet.The concern sheet should gets visible when I select option box or Check box.

problem no. 2
I have given the data of Japan & China Plants. Now the total production of japan Plants are sum of plant 1,2 &3. But production of China plants are variable & need to fix by us. We will put production terget in China Plant 1, 2 & 3 in such a way so that one message box written "please check your data" should be appread whenever the K25/26/27/28/29 dont match with E25/26/27/28/29.


View Replies!   View Related
Another Sheet To Show Each Class Down The Rows And The Columns To Show Each School Rule
I have an excel 2003 sheet that collects data from Infopath forms. The forms are to record students who have broken school rules, when, where, repercussions etc. One column shows their class and there is a separate column for each rule broken.

I want to create another sheet to show each class down the rows and the columns to show each school rule. Therefore, each cell would show the number of each particular rule broken for each particular class. I have tried to do countif and sumproduct (if on sheet 1, column B the class is KA and on sheet 1, column M, the rule is bullying = how many times this has occurred).


View Replies!   View Related
If A Cell Has Data Show It If Not Show 0
I have a column of data held in column B.

I am required to show the following.

If there is data in the cell then it is to be left. If there is no data in the cell then I would like to show the value 0.

I have tried using a circular reference, using the formula =IF(ISBLANK(B1),0,B1) and other similar formulas but they dont work as the formula overwrites the data in it.

do I need a macro?, or conditional formatting?

View Replies!   View Related
Add Drop List Box Or Combo Box In Yearly Time Sheet
how to add drop list box or combo box in this yearly time sheet so every employee has his own record in this time sheet so when ever i select name from drop list all info changed, i did include table in sheet 1 as an example.

View Replies!   View Related
Nested AutoshapesL: Display Several Pairs Of Boxes, Which Consist Of A Descriptor Box And A Value Box
I have a problem when using autoshapes. Above a display of columns of data, which are of different widths, I need to display several pairs of boxes, which consist of a descriptor box and a value box. If I use formatting in cells, I am constrained to use the width of the columns below. So I will be using autoshape rectangles. No limit on box widths and I can link each one to a cell to send text to them. So far so good.

However, I would like to contain a group of these box pairs within another autoshape. When I do this, if I fill the outer autoshape with colour, I have the choice of making the colour solid, which means you can't see the inside box pairs at all, or semitransparent, which allows the boxes to loom through a fog of the outer colour. What I would like is for the inner boxes to show properly, and fill only the space between the inner boxes and the rim of the outer autoshape

View Replies!   View Related
Text Box To Display Info Related To Combo Box Change
I have a combo box named Combobox5 and a text box named Textbox7.

Should this code go in the Userform Initliaze or where? I have tried placing it in both the ComboBox5 Change evnent and no luck so far.

Range("G22:J28").Value = TextBox7.Text
Again this code is dependant upon the user making a choice from ComboBox 5.

I have also tried:

Range("G22:J28").Value = TextBox7.Value
I am using Excel 2003. Any ideas??


View Replies!   View Related
User Form - Select From Combo Box And List Box Should Populate
I've created a user form (click button on 'main page' to display). Combo Box called 'Last name' gets populated with all second names from the sheet 'Staff'

When a user selects a second name from the drop down list, I would like excel to automatically update the list box 'First Name'. Also, If a user changes the first name or Last Name, this should be saved


View Replies!   View Related
Activate A Macro From Combo Box / List Box
I'm trying to figure out how to activate a macro from combo box or list box.
But no success.

I have a list of names:
AAA
BBB
CCC
111
222
333

That I can view through the combo box.

I have created a list of macros, that carry the same names,

AAA
BBB
CCC
111
222
333

The Q is: how can I link each name to its own macro?
so when chosen, will activate the macro?


View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved