Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    58

    Re: Erase values linked to external files

    Hi and thanks for the reply!

    Im going to try this code, but in the meantime, I would like to know if it is possible to delete all the values that came from any external link.

    Thanks!
  2. Replies
    3
    Views
    58

    Erase values linked to external files

    Hi all,

    I wonder if there is a code for doing the following:

    I have a WB called WB1 with Sheet1 with links to another WB, called WB2, Sheet2.

    Is there a possibility to delete all the values...
  3. Re: Not allow users to hide columns in protected sheet

    This code is great! I think it is enough for what I need. When someone tries to save the WB with a hidden columns, the columns just are unhidden right?

    Thanks!
  4. Re: Not allow users to hide columns in protected sheet

    Thanks for the code! I think this is close to what I need.

    It is possible that when I change to a sheet, is is forbidden to hide the columns?

    Thanks!
  5. Not allow users to hide columns in protected sheet

    Hi all,

    I have a protected sheet, where I want the users to be able to change the size of the columns but not to hide them.

    In the option "Protect sheet" I can unable "Format columns", but If I...
  6. Re: Merge different workbooks into one workbook. Setting order

    Thanks I will try this!
  7. Merge different workbooks into one workbook. Setting order

    Hi all,

    I hope you could help me with this.

    I have 3 closed WB in a folder, in the following terms:

    A) WB "A". With one sheet called "A"
    B) WB "B". With one sheet called "B"
    C) WB "C"....
  8. Replies
    4
    Views
    122

    Re: Code to split and rename files

    Thanks John and sorry for my late reply!

    I will try this macro and sure it will work.

    Thanks!
  9. Replies
    4
    Views
    122

    Re: Code to split and rename files

    Hi John,

    could you please send me the macro?

    Thanks!
  10. Replies
    4
    Views
    122

    Code to split and rename files

    Hi all,

    I have a PDF with 20 pages and I want to split it into 20 different pages. I wonder if, appart from the first petition, could it be possible to rename those files that are going to be...
  11. Re: VBA code to change font color from red to black

    This is just what I wanted. Thanks very much for your help!! This code is great!
  12. Re: VBA code to change font color from red to black

    Yes please
  13. Re: VBA code to change font color from red to black

    Thanks for the last code.

    I have an idea. What if we replace in all the workbook the text "in (-)" that is in red for the text "in (-)" in black?

    This will solve my problem.

    Thanks!
  14. Re: VBA code to change font color from red to black

    Hello, this is working almost perfect! But... what if in the same text there are part text in black font and part text in red font? In this case, it is not changed to black.

    Thanks again!
    ...
  15. Re: VBA code to change font color from red to black

    Hello,

    Yes, I have fonts in white, red, black and another colours.

    It would be perfect to have a code that finds every text in red in the workbook and change the color into black.

    Thanks!
  16. Re: VBA code to change font color from red to black

    Hello.

    It is hardcoded. Is there a code for this?

    Thanks!
  17. VBA code to change font color from red to black

    Hi all,

    Im looking for a code that changes in all the workbook, all the text that is in red colored (red font), into black (black font).

    Would it be possible?

    Thanks in advance!
  18. Re: Cells are erased when opening file in Repair mode/Extract data

    Hello! Any help please?

    Thanks!
  19. Cells are erased when opening file in Repair mode/Extract data

    Hi all,

    something weird is happening to my Excel files. I receive some Excel files with Financial information from some countries and I need to repair these files, because they are not working...
  20. Re: Code to translate all workbook based on translation table

    Hello,

    Ive been testing your code in the last few weeks and as I reduce some time, it is taking me 13 minutes to run all the code.

    Do you know another way to translate a book of 40 sheets and...
  21. Re: Expand/Collapse in Worksheet not protected by VBA

    Sorry for answering so late.

    Finnaly I have dediced to save the fie in .xlsm and insert in my protecting code "EnableOutlining = True ".

    Thanks for your time!
  22. Re: Expand/Collapse in Worksheet not protected by VBA

    Many thanks for your help.

    I did what you proposed and It worked well, but when I close and reopen the book (saved in .xlsx), I cannot expand and collapse.

    Probably with your code I could work...
  23. Expand/Collapse in Worksheet not protected by VBA

    Hi all,

    I need to protect a sheet and let the user to expand and collapse rows and columns.

    I also need to save this WB in .xlsx (not in .xlsm) so I cannot use macros (as far as I know).

    Is...
  24. Re: Code to translate all workbook based on translation table

    Hello,

    this is my full code. It is excluding the sheet "Translation" so I think I do not need to copy it in another WB. I also included ScreenUpdating and others codes to make it faster.

    My WB...
  25. Re: Code to translate all workbook based on translation table

    Many thanks for your help. I have one question.

    Why I need to copy the sheet Translation to another WB? I have tried to do everything you proposed and still the process is too slow.

    Thanks!
Results 1 to 25 of 100
Page 1 of 4 1 2 3 4