Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Search box to hide rows that don't contain

    Is there any way to get this code to look at a textbox value not ("AQ12")?

    Thanks Jason Bing
  2. Re: Search box to hide rows that don't contain

    Wow that works very well.

    Added a few things to speed it up and deal with sheet protection

    Screen updating = false etc

    Thank you very much. its help from people like you that really show...
  3. Search box to hide rows that don't contain

    I have a sheet with a list of customer orders called (FTBJOB2) the data is contained in cells A to AP of the table starting from row 13

    I Know how to make a combo box that places whatever is...
  4. Replies
    9
    Views
    228

    Re: Hide headings in all worksheets

    Completely. Yes

    Thank you

    Jason
  5. Replies
    9
    Views
    228

    Re: Hide headings in all worksheets

    I don’t have this line in that macro. I appears to be all the other macros with this line in it. Something about some of the other macros with

    Activesheets.unprotect “” in them.

    I can select...
  6. Replies
    9
    Views
    228

    Re: Hide headings in all worksheets

    Thanks for the reply. I am getting a Run-Time error 1004

    Unprotected method of worksheet class failed. this is in another unrelated macro in a different module. It is appearing in the


    ...
  7. Replies
    9
    Views
    228

    Re: Hide headings in all worksheets

    This works great in the test book, thank you

    However the sheets are all protected in the master database

    What do I have to add to the code to unprotect the sheets then protect after

    Thanks
    ...
  8. Replies
    9
    Views
    228

    Hide headings in all worksheets

    No doubt this has been covered before

    is there a VBA to hide the headings in all worksheets

    Thanks everyone

    Regards

    Jason Bing
  9. Re: Copy cell value to another sheet and paste into cell (D) of row containing sheet name

    Oh I almost forgot. The sheets are all protected. Not with a password, just to prevent people inadvertently changing things


    Thanks wonderful people

    Jason Bing
  10. Copy cell value to another sheet and paste into cell (D) of row containing sheet name

    I am going around in circles!!! Please help!!

    I have a sheet called "FTBJOB2" containing a list of job numbers in column B and the "job status" in column D.

    With each new job a new sheet is...
  11. Re: Dynamic list of worksheets based on tab colour

    Awesome mate you are a legend. Now it works with the guys fat fingers.

    Have a great day

    Thank you

    Jason Bing
  12. Re: Dynamic list of worksheets based on tab colour

    sorry to clarify yes this the formatting for the index page

    Thanks

    Jason Bing
  13. Re: Dynamic list of worksheets based on tab colour

    Thank you.

    The colour formatting is fine, it is controlled by a conditional format and works well

    The Font name I need is Arial

    And the font size I would love to be 28. We use a touch...
  14. Re: Copy entire row and paste it in another sheet

    I see your point.

    Let me clarify with more detail. It was late last night when I posted this! There is a better question for what I am trying to achieve.

    There are two parts to the job...
  15. Copy entire row and paste it in another sheet

    I need a code to do the following.

    I have a sheet of job numbers (called FTBJOB2). The job numbers are located in column b of each row. There is then data pertaining to that job in the remainder...
  16. Re: Dynamic list of worksheets based on tab colour

    There is one small niggle. I do feel a bit picky asking. But is there a way to prevent the refresh from resetting the format. The guys use a touch screen with this workbook and the small format...
  17. Re: Dynamic list of worksheets based on tab colour

    Mate. Your are a legend. The code works perfectly. I did add a few lines to unprotect and protect the sheet (I forgot to mention the sheets were protected) but in is exactly what I needed.

    ...
  18. Re: Dynamic list of worksheets based on tab colour

    WOW That seems simpler

    The job status is recorded in cell "Y2"

    Thanks Again

    Regards

    Jason Bing
  19. Replies
    18
    Views
    560

    Re: Returning Home

    Thanks for the reply. Testing the code everything seemed to work great. I would navigate to another sheet, leave it and it returned to sheet 1, after the allotted time. However if the workbook is...
  20. Replies
    18
    Views
    560

    Re: Returning Home

    It would be great if it worked all the time.

    Thank You fir your time

    Regards

    Jason Bing
  21. Re: Dynamic list of worksheets based on tab colour

    This is true. I see your point

    Here is what I am trying to do. I have a macro that creates a new sheet from a template. They activate the cell with the job number on it and then this macro takes...
  22. Re: Change Cell Button to apply to all selected cells

    Well that was obvious. I am a VBA Student, I have much learning to do

    Thanks Guys

    Regards

    Jason Bing
  23. Change Cell Button to apply to all selected cells

    I have had a request from management. I have the following macro assigned to a button




    Sub TaskNotDone ()
    With ActiveCell
    .Value = "N/A"
    End With
  24. Replies
    18
    Views
    560

    Re: Returning Home

    The code worked beautifully on the test workbook and on the master project. Little problem though, it only works once!

    To get it to work again you have to close the workbook and reopen it. Then it...
  25. Replies
    18
    Views
    560

    Re: Returning Home

    Thanks for the reply’s. Will test when I get back to the office. Yes I did save exit and RE open. Thanks for the input.

    Regards

    Jason bing
Results 1 to 25 of 49
Page 1 of 2 1 2