Automatic Excel translation spread sheets

[Bears3898]

Is there a option that forces all your email or as you open a spreadsheet in English that can translate to Dominican Republic language?

Thanks,
Bears3898

 

[Roxxien]

You want to translate the text or formula/software?

 

[Bears3898]

Roxxien
thanks for the reply
the text
inwant the spreadsheet to come in Spanish like is always does, then I have to highlight the spreadsheet and paste it into goggle translate, then copy that and dump it back into a new excel spreadsheet and it's not formatted very hard to work with, takes a lot of time. I would like to open the spreadsheet click translate and have it appear in the same format in English.

thanks,
Bears3898

 

[Roxxien]

As you need to translate the text itself, I think the way to should do it is with the VBA dictionary which I have never use.

I refer you to this post

VBA Dictionary Macro to find and replace (translate) text