I have multiple ranges ( with range names assigned) in a workbook. I would like to export all the range data into multiple jpeg files to my local drive using VBA. I know how to do it one at a time. It is very tedious and time consuming since I have 100 of those in the workbook. I would like to...
Hi:
I am not talking about new workbooks. I get workbooks from other users with multiple worksheets ( more than 25) and each having different fonts. I would like to set the font and size same for all the worksheets in the workbook. It is tidious to do manually. Is there a way to do this using...
I want to add a .wmv file as a part of VBA useform in excel. I am creating a dashboard with a help feature. When users click the help feature, I want the user form to show the .wmv file which has the video.Does anyone have a cool way to embed a .wmv file?