Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vickycmha

  1. vickycmha

    Inserting lines into a protected Excel spreadsheet

    As to the # of rows to include, staff need to insert the additional rows in date order, and therefore have to insert in the middle of the document. These documents then have to be printed and submitted to supervisors for authorization. I wouldn't want the printed documents to be even more...
  2. vickycmha

    Inserting lines into a protected Excel spreadsheet

    If I'm understanding you properly, I have already set the formulas/headings to "locked" and the deselected locked for the data area. However, when the sheet is protected, it won't allow the insertion of additional lines in the body of the form.
  3. vickycmha

    Inserting lines into a protected Excel spreadsheet

    If I put the totals and formula at the top, I still wouldn't be able to lock those cells to prevent anyone from overwriting. They would still need access to add lines below into the appropriate date range.
  4. vickycmha

    Inserting lines into a protected Excel spreadsheet

    Wow, quick response. The form is a mileage claim form, where entries have to be in date order. There can be multiple entries per day...totally unpredictable. It merely totals all entries and multiplies by the prescribed rate. How do I do "code
  5. vickycmha

    Inserting lines into a protected Excel spreadsheet

    I have created a form in Excel which I need to protect in order to lock specific cells containing formulas. However, I also need to allow staff to insert additional lines as needed. Does anyone know a way to achieve both objectives?
  6. vickycmha

    Excel Combo Box - Overriding Values

    MatchRequired is set at False MatchEntry is set at 2 - MatchEntryNone I have gone through each detail of the properties, but can't get it to work the way I'd like. I am working in Excel 2000 if that makes a difference. I certainly don't have the skillset of a programmer, so it appears I'll...
  7. vickycmha

    Excel Combo Box - Overriding Values

    I have selected "2 - fmMatchEntryNone" for MatchEntry, but it had no affect.
  8. vickycmha

    Excel Combo Box - Overriding Values

    I have set up my list of values with the most frequently used values. However, there can be one time entries necessary which can't be anticipated. I would like users to have the ability to type in a value other than the choices on the list.
  9. vickycmha

    Excel Combo Box - Overriding Values

    Thank you. Unfortunately, I have no experience in Visual Basics or ActiveX. I added the combo box through the Control Toolbox in Excel, selected and named the value range. I have tried changing the MatchRequired property to False, but it still won't allow the override. Vicky :(
  10. vickycmha

    Excel Combo Box - Overriding Values

    I have created a combo box in an Excel spreadsheet and assigned a range of values to populate it. I would like the user to have the ability to override the value options if necessary to type in an alternate value. Is this possible? If so, how is it done?
See more

Part and Inventory Search

Back
Top