Macro

Hi Esther

You can add a button rather than pressing a Ctrl key in 2 different ways as folows.

1. To add a macro button in your worksheet...
Select Insert, Shapes.
Choose a rectangle or any shape for your button.
Size, position and colour your button.
To add text just type while it is selected.

Then Right click on the shape and choose Assign Macro
Select the macro from the list.

Tip: To stop the button resizing or moving if your macro involves filtering or hiding rows:
Right click, Size and Properties
Properties tab
click Don't move or size with cells.

To add a macro button on the Quick Access toolbar...

Click the dropdown icon on the right of the Quick Access toolbar (the toolbar at the top right of the screen)
Select More Commands
Select Choose commands from - Macros
then click Add for your macro
Choose Modify to change the button image
Click ok

This second method is formore general macros for use in any workbook.

Hope that helps for now

Regards
Doug Dunn
Best STL