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.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    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

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

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

.xlsm

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

.xltx

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

.xltm

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

.xlam

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


Hi,
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)

9 Answers

Excell Password


5a6e9ecb-a5cc-4ddc-a33e-3db0180df311.png
Would you like to recover excel file password so just try PDS Excel password recovery software this software quickly works on your password protected Excel file and get back your original Excel file password, This Microsoft Excel file password recovery software magnificently recover password MS Excel file and also let you use your locked XLS and XLSX file again without creating any problem more. With the help of MS Excel sheet password recovery software you can easily recover password MS Excel sheet with fully previous data of your locked Excel file. PDS Excel file unlocker tool gives you free Excel unlocker software which shows you first three characters of your original Excel file password. if you want to recover whole Excel file password then you can get full version software.

Free Excel Password Recovery
Buy Excel File Unlocker

Mar 04, 2008 | Microsoft EXCEL 2004 for Mac

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

EXCEL


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:

104 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...