借罗老师的VBA给你借鉴吧
Sub 创建一个快捷方式()
Dim WshShell As Object, oShellLink As Object
Set WshShell = CreateObject("WScript.Shell")
Set oShellLink = WshShell.CreateShortcut(WshShell.SpecialFolders("Desktop") & "\快捷方式.lnk")
oShellLink.TargetPath = ThisWorkbook.FullName '指定快捷方式的目标文件
oShellLink.WindowStyle = 1 '窗口状态/运行方式
oShellLink.Hotkey = "CTRL+SHIFT+F" '打开该文件的快捷键
oShellLink.IconLocation = "explorer.exe, 0" '指定一个图标
oShellLink.Description = "这是一个快捷方式"
oShellLink.WorkingDirectory = WshShell.SpecialFolders("Desktop")
oShellLink.Save '保存
End Sub