Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Got it! I wasn't following through with the save process since I am just testing it and it kept showing the 1 in the name of the file until I tried to actually save it and it dropped the number....
  2. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Additionally when I open the template with the Workbook_Open code I get a Compile error: Procedure declaration does not match description of event or procedure having the same name.
  3. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Yes that is when the "1" is added to the file name. The template doesn't have the "1" only what is produced from the template
  4. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    I put this code in the original macro enabled excel workbook within the "ThisWorkbook" object and saved the workbook as a template and once reopened it added the "1" again. Is that not the process...
  5. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    The user will pick where it goes (as one is needed for every work packet) but the name should remain the same as the original template just not a template "BoilerPlate Rev3" not "BoilerPlate Rev31"....
  6. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    I understand, that is why I came here cause I'm struggling with it on my own.
  7. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    I don't think you understand my question.

    I have a template that I maintain and is used as a template, all users open the template and save out into their file as a workbook (yes it is a...
  8. Re: How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Original is a template that users go to and save as a workbook. I don't want the workbook to end with a "1" as excel auto inputs when saving from the template. users do not save as template they save...
  9. How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Is there a setting or a macro that could disable the auto function of a macro-enabled template from adding a number?

    I have a workbook that is used for every bit of work done in house, and is...
  10. Replies
    1
    Views
    84

    convert Chart to picture

    I need to generate a report by pressing a button.
    I use VBA to extract worksheets to a new workbook using a button a lot, but this one I can't figure out.
    What I would like is for the 2 charts on...
  11. how to allow multiple entries in a cell with a formula in custom data validation?

    I have a column in an excel sheet that users input data I want to make it so they can't miss something important. Using data validation custom formula works great to ensure the user only inputs...
  12. Re: Can I use VBA to change a cell that already contains a data validation

    Not exactly. B2 is selected from a static drop-down, B4 is different drop-downs dependent upon the selection is B2 (formula in data validation source).

    B24 is also different drop-downs, dependent...
  13. Re: Can I use VBA to change a cell that already contains a data validation

    Thanks for trying to help. Sorry my question wasn't clear. B2, B4, and B24 all have drop downs and the drop down in B4 is dependent upon what is selected in B2 I have no problem with that my problem...
  14. Re: Can I use VBA to change a cell that already contains a data validation

    Can't use quotation marks in the vba, the problem with my code is the named ranges. I can't put your code in B24 because I need drop downs and I can't put your code in source for Data Validation...
  15. Re: Can I use VBA to change a cell that already contains a data validation

    I've tried


    Private Sub worksheet_change(ByVal target As Range)
    Application.ScreenUpdating = False
    With Range("B24").Validation
    .Delete
    .Add Type:=xlValidateList,...
  16. Can I use VBA to change a cell that already contains a data validation

    I have an excel sheet that users have to input data to access their forms, on the first sheet in B2 the user picks a project and in B4 the user will pick a sub-project. In B24 there is a data...
  17. Re: UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

    That was the trick!! Thank you so much!!! :)
  18. Re: UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

    Yes it is. There are a bunch of different options but I only want the userform if one option is chosen.
  19. Re: UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

    This stopped the userform from opening at all.
  20. UserForm dependent upon cell content. Now opens every time any cell is selected the userform opens again.

    I have it so that the userform only shows when "XYZ" is selected from a drop down in B2.
    But now even after it is satisfied if I select any other drop down in any other cell of this worksheet the...
  21. Re: how to extract a string of numbers from a cell containing text and numbers

    Thank you SO much!!! This is exactly what I needed!!
  22. Re: how to extract a string of numbers from a cell containing text and numbers

    this macro just deleted the "RE". there is a lot of other information in each cell in column A. the result needs to just be RE##### but I need everything after the RE until there is a space.
    so for...
  23. how to extract a string of numbers from a cell containing text and numbers

    I have an excel list of over 5 thousand cells in a column. All in column A.
    Each cell is unique with different information in a different order.
    I need to extract from each of these cells the...
  24. Hiding OLEObjects based on data validation on a different worksheet

    Hi I have run into a roadblock that I just can't figure out, I would really appreciate any help I can get.

    On sheet 2 in B2 there is a data validation drop down list that has 6 different options....
  25. Replies
    4
    Views
    286

    Re: using IF and AND and OR

    So this did work exactly the way I originally explained but once I started testing it I realized that what I need is a bit more complex.
    E column should show "YES" if C and D have either both "YES"...
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4