Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Daryl Butler   on Mar 18 In MS Office Category.

  
Question Answered By: Maria Miller   on Mar 18

You could simply check for the existence of the shortcut  in
the "DeskTopIcon" subroutine just before creating the shortcut by
enclosing the shortcut creation code  inside the if...then like this:

If Not Dir(MyShortcut) <> "" Then
With MyShortcut
.TargetPath = ActiveWorkbook.FullName
.Save
End With
Set WSHShell = Nothing
MsgBox "A shortcut has been placed on your desktop  for ' " &
_
ActiveWorkbook.Name & " '"
End If

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Desk top icon Or get search suggestion and latest updates.


Tagged: