Macro button on desktop

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,199
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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

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