Search:

Type: Posts; User: BadgerRoad; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    I said "Worksheet Selection". I meant Worksheet Protection".
  2. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    You can do that in the Worksheet Selection process. The top two boxes allow you to Select Locked Cells and Select Unlocked Cells. If you uncheck the Select Unlocked Cells it prevents the user from...
  3. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    What are you trying to accomplish by protecting the Workbook?
  4. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    You can do what you you are asking.
    1. You need to unlock each cell that you want to allow the users to edit. You need to unlock each cell you want to allow to be edited. To do this, right click the...
  5. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    Is there is a question in your response?
  6. Replies
    12
    Views
    590

    Re: Protecting cells and total workbook

    You can protect the Worksheet and the Workbook separately, assuming you are using a later version of Excel. I think it started in Excel 2007, but I'm not entirely sure. Go to the Review Tab and you...
  7. Re: True value on spreadsheet to fill 'x' on checkbox in Userform.... Help!

    You can enable the manually by changing the Enabled Property or you can do it through code. I would suggest you enable them, run your code and see if they become disabled again. If so, it's happening...
  8. Replies
    2
    Views
    193

    Re: Solver - Maximise 2 variables

    You can only maximize one variable with Solver. Also, it is very possible you would have multiple solutions producing the same result.
  9. Replies
    8
    Views
    323

    Re: Retrieving data from a .txt file

    You can import the data. There is a "from Txt" option under "get external data" under the Data tab.
  10. Replies
    1
    Views
    126

    Re: open and close userforms

    Unload TouchPadForA_Cognitive
    Load TouchPadForA_PSMT
    TouchPadForA_PSMT.Show
  11. Re: Can I password protect access to selected worksheets inside a workbook?

    You can password protect a worksheet which prevents a user from editing it, but it doesn't prevent a user from seeing its contents. If you simply hide the worksheet then any user can unhide it and...
  12. Re: I've got a tough one for some math experts.. :)

    This is similar to a problem I have in woodworking where I need to cut cabinet parts out of sheets of plywood. I use a product called CutList Plus which costs around $89 but is well worth it. There...
  13. Replies
    5
    Views
    389

    Re: Making Best Use of Wood

    I have a piece of software that I purchased called CutList fx that I think does what you are asking. I can't remember what I paid for it but it wasn't much. I find it invaluable for laying out...
  14. Replies
    2
    Views
    161

    Re: Fraction formatting

    Do you have it formatted "Up to 2 digits"? If it's only formatted as one digit it will change 3/10 to 2/7.
  15. Replies
    33
    Views
    1,358

    Re: Formula to calculate profit

    If I understand you correctly, you want to charge tax on the sales price and profit on the sales price. If that is correct then sales price = cost/.75. Correct?
  16. Replies
    33
    Views
    1,358

    Re: Formula to calculate profit

    If I understand this correctly, you bought 100 phones at a cost of $1000 plus $150 tax for a cost of $1150 per phone. Total investment is 1150 x 100 = $115,000.
    Then you bought another 100 phones at...
  17. Replies
    10
    Views
    299

    Re: Serious help

    What kind of formula? Without more details it's impossible to tell.
  18. Re: Use Excel to solve a complex algebraic equation?

    One easy way is to use Goal Seek.
  19. Replies
    6
    Views
    185

    Re: Formula Help

    This is a geometric series with 7 terms and a common factor of .3. So the formula is 10000*(1-.3^8)/(1-.3)=14284.78.
    In general, if you have a common factor of k and n terms the formula will be...
  20. Re: changing all current cells to all uppercase and forcing all future entries to be in uppercase

    To force all entries to upper case insert the following:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Target = UCase(Target)
    Application.EnableEvents...
  21. Replies
    3
    Views
    151

    Re: insert credit card payment button

    You are welcome, and welcome to the board.
  22. Replies
    3
    Views
    151

    Re: insert credit card payment button

    Create an ActiveX button and on the Click Event for that button and insert the following code:

    ThisWorkbook.FollowHyperlink Address:="http://www.whatever the link for the credit card company.html"...
  23. Re: Determine Number of Monthly Loan Payments with Additional Payments

    =nper(a2/12,-(a3+a4),a1)
  24. Replies
    8
    Views
    132

    Re: If Statement

    I wasn't sure and still am not sure which way he meant that. Anyway, I like your solution better if it does what he wants.
  25. Replies
    8
    Views
    132

    Re: If Statement

    Are you sure my middle condition is missing? He doesn't have any condition between .2 and .4 the way I read it.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4