REPEAT VBA FOR ENTIREBOOK

  • hi dears

    i have this 2 macro for excel to jpg convert and work perfectly , but my workbook have 10 sheets and i must repeat this code for every sheets . i need change these codes

    macro a :

    1-for do it for entire workbook automativally and with no question

    2-every export jpg file name is same as sheet name in my excel file path

    3- this macro need select range before run it . i need automatically, printarea by default selected for each sheets , for to convert in jpg .


  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too.

  • If I've been helpful, let me know. If I haven't, let me know that too.