Results 1 to 3 of 3

Thread: Macro button on desktop
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,478
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Macro button on desktop

    Is it possible to have a button on the desktop which would open a msgbox & then two options.

    Selecting one option to open this workbook selecting the other option would open a different workbook.
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  2. #2
    Board Regular
    Join Date
    Jan 2015
    Posts
    1,121
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro button on desktop

    It is possible to have a
    file or s
    hortcut which, when you double click it, hides application and shows a userform only on opening event

    Code:
    Private Sub Workbook_Open()
    
    Application.Visible=False

  3. #3
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    7,351
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Macro button on desktop

    As suggested by Kamolga, you could have a file shortcut on the desktop that opens the workbooks.

    Maybe have a vbscript shortcut clicking on which will prompt the user with the MsgBox .
    Office/Excel 2010 64Bits -- Win10 64Bits

    Common sense is not so common.


    http://photo-larache.blogspot.com/

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •