excel macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Macros

Excel Macros

resolvedResolved · Low Priority · Version 2003

Craig has attended:
Excel Advanced course

Excel Macros

Is it possible to import custom button images?

RE: Excel Macros

Hi Craig,

Thank you for your question.

I know of no way of importing images into the Change Button Image box. However, you can right click over an exisiting picture and copy it. Add a custom button to your toolbar and keep the Customise dialogue box open. Then right click over the custom button and choose Paste Button image.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips


Server loaded in 0.08 secs.