Macro button on desktop

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,832
Office Version
  1. 2007
Platform
  1. Windows
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.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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()
[LEFT][COLOR=#000000][FONT=Droid Sans Mono][COLOR=#000000][FONT=Droid Sans Mono]Application[/FONT][/COLOR][COLOR=#000000][FONT=Droid Sans Mono].[/FONT][/COLOR][COLOR=#000000][FONT=Droid Sans Mono]Visible[/FONT][/COLOR][COLOR=#000000][FONT=Droid Sans Mono] [/FONT][/COLOR][COLOR=#000000][FONT=Droid Sans Mono]=False[/FONT][/COLOR][COLOR=#000080][FONT=Droid Sans Mono]
[/FONT][/COLOR][/FONT][/COLOR]
[COLOR=#000000][FONT=Droid Sans Mono][COLOR=#000080][FONT=Droid Sans Mono]
[/FONT][/COLOR][/FONT][/COLOR][/LEFT]
 
Upvote 0
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 .
 
Upvote 0

Forum statistics

Threads
1,224,816
Messages
6,181,139
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top