Surface Pro (2017) vs Surface Pro 4
I use a specific sheet on a regular basis at work which requires insertion of a picture of my signature as approval, might sound a bit risky, but it's just for minor internal stuff. I currently have the image in a Word doc that I have to keep opening, copy/pasting across each time. Bit of a pain. Question is, does anyone know if there is a way of creating a shortcut that can do this for me either with shortcut keys or a macro? I don't know if I can open another package with an Excel macro.
Easy when you know how, thanks VoG™. Could you refresh my memory on how I can make that available to all open workbooks please? What happens is, numerous people around the plant create the workbook on their pc, send it to me for approval, and it gets shipped on to a supplier, so if poss I'd like the macro to be always there whenever I open any old Excel file, as they are not created on my machine, so I cant use the XLstart file, can I do that?
Record your macro and ensure that it works.
ALT + F11 to open the Visual Basic Editor, if necessary click in the left hand pane on Modules then on the name of the module your macro is in (probably Module1). File > Export and save the module. Save and close the workbook.
Open a new blank workbook, ALT + F11 then File > Import and import your module. Close the VBE. File > Save As and in the file type dropdown select Microsoft Office Excel Add-in (*.xla) - normally at the bottom of the list. Close the file.
Tools > Add-ins, click the Browse button, find and click on the Add-in file that you just saved and click OK.
The macro should now be available in any Excel file on that PC.
Marvellous, thanks VoG™, 1st for Excel as usual.
Just finished setting that up, works a treat of course, as if there was any chance it wouldn't.
We've just had Office 2007 rolled out across our company, and now my trusty signature macro (As above) is gone. Or was. I tried to do the same thing in Excel 2007 as I had done in '97, but the macro recorder would not pick up the 'Insert picture' steps. I started new macro, entered name/info etc and went through the insert picture moves from the ribbon, but when I stopped macro recorder, and looked at the code for macro, all that was there was start, info that I'd added and end, nothing in between. Luckily I still have '97 on my pc, so did it again in that, to check I'm not mental, and all worked fine, tried again in 2007, and it doesn't grab the insert picture steps. I've worked around it by copying the code across from '97 VBE into my 2007 macro, so my macro is now working OK in 2007, but I'd like to know how it should be done in 2007, as eventually, we will have '97 uninstalled. Any ideas?
Oops, in hindsight, probably not a good idea to continue a resolved thread. Please don't add to this one, as I've started a new thread.
This thread is now locked and can not be replied to.