ExcelBanter - Shortcut Key Creation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Shortcut Key Creation (https://www.excelbanter.com/excel-worksheet-functions/220480-shortcut-key-creation.html)

vlhogg5

Shortcut Key Creation

Shortcut Key Creation
I would like to make a save and close shortcut key in Excel.
Can anybody help me?
Thanks

mdmackillop[_14_]

Shortcut Key Creation

Code:
--------------------
Sub CloseSave()
ActiveWorkbook.Close True
End Sub
--------------------

To create a shortcut Tools/Macros/Option

--
mdmackillop
------------------------------------------------------------------------
mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62817

All times are GMT +1. The time now is 06:47 PM.