Question about Computers & Internet

1 Answer

Password Hi I would like to have password prompt when user tries to use macro button after data entry. Do not want to password protect total work sheet just macro button.

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 30 Answers

Hello, if you are using a vb program, i know a code that will allow you to make a password protect your programs. But you are prompt to enter it in every time you start the program.
Private Sub Form_Load()
passwordbox = InputBox("Please Enter Key")
If passwordbox = "Put Your Password Here!" Then
MsgBox "Welcome!"
Else: MsgBox "You have entered the wrong password"
Unload Me
End If
End Sub
You can try this. Hope this can help you in some way :)

Posted on Feb 29, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How to softwhere reset GTX75 airtyme torrid mobile

Try this: The web interface offers a simple way to reset to factory defaults. It is necessary to login to the phone`s admin account to perform a full reset. Go to the "Advanced" screen. Click on "Factory Reset" then "Submit" and "Reboot phone". Early manufactured phones can be reset to factory defaults, including admin and user passwords, using the undocumented ATE menu feature. 1) Invoke the ATE menu and wait for the "Func No:" prompt. 2) Enter 37 and press the green key. Wait for "Success" and press red key. 3) Enter 38 and press the green key. Wait for "Success" and press red key. 4) Enter 41 (=Clear User Data) and press the green key. Wait for "Success" and press red key. 5) Turn the phone off and back on - it should be totally cleared and the default passwords will be set. WARNING: Performing the ATE reset will also clear the phonebook entries and all user-specific settings.

Apr 16, 2016 | Cell Phones

1 Answer

Screen is locked and nothing is working...

Hi Kris A Hemenway-Sheets, Condolence to your family. I just want to ask if the phone is Android, what version is it? If its 4.4 and below, enter a wrong pattern or PIN five times. You'll see a "Forgot pattern," "forgot PIN," or "forgot password" button appear. Tap it. You'll be prompted to enter the username and password of the Google account associated with your Android device.

Nov 06, 2015 | Samsung Galaxy Cell Phones

1 Answer

How to change password on blackberry when you don't know the password?

If you or a user turns on content protection for a BlackBerry device that is running BlackBerry Device Software version 4.3 or later, you can reset the BlackBerry device password using a BlackBerry Enterprise Server version 4.1 SP5 or later. The BlackBerry Enterprise Solution uses the remote password reset cryptographic protocol to reset the BlackBerry device password when content protection is turned on. The BlackBerry device does not prompt the user for the old BlackBerry device password.
The remote password reset cryptographic protocol is designed to provide the following features:

* permit the BlackBerry device to encrypt the content protection key again with the new password, without the old password being available
* prevent a hardware-based attack on the BlackBerry device from recovering the content protection key without knowing either the BlackBerry device password or the IT policy private key that the BlackBerry Enterprise Server generates for the BlackBerry device
* prevent the BlackBerry Enterprise Server from accessing any data that a potentially malicious user could use to recover the content protection key

To reset the BlackBerry device password, you send the Specify new device password and lock device IT administration command to the BlackBerry device. You should send the IT administration command to a content-protected BlackBerry device that is in the possession of the BlackBerry device user only. If you send the IT administration command to a BlackBerry device that is in the possession of a potentially malicious user, that user can use a hardware-based attack to recover the key pair that the BlackBerry device created when it received the IT policy. The potentially malicious user can use the key pair to decrypt all the data on the BlackBerry device.

* Process flow: Resetting a BlackBerry device password when content protection is turned on

Proceed on this link : ID PASSWORD RESET

Aug 06, 2011 | RIM BlackBerry 8703e Smartphone

2 Answers

What is exel sheet extension in office 2010 ?

Excel Workbook


The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook


Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template


The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template


Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In


A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

Hi, I've go a VBA macro that runs fine in Excel 2003 but I get the Run time error '-2147467259 (80004005)': Method 'MaximumScale' of object 'Axis' failed I'll send you the macro if you want. A small t...

I assume you mean that it's fine in 2003 but errors in 2007? If this is the case, then you may want to check the protection on the sheet. With 2007, you will run into this error everytime the macro tries to update a password protected sheet or portion of a sheet.

Hope this helps!

Oct 02, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Excel support

Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
Hope this helps.
Glad to be of assistance - please rate the solution I can learn from you. Thanks

Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

5 Answers

Forgot password to open Excel sheet

If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Excel password removing

could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

One problem in the application of excel sheet

I can make out that
You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet.
You will need to get precise help from a programmer on this.
If you want to see a little on macros just open a sheet and checkout the help section on macros.
Some macros can take many hours to write and test.Some make take months.
hope this helps.

Jan 30, 2008 | Microsoft Windows XP Home Edition

1 Answer


I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

105 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides