Desktop Shortcuts Done By VBA

Sep 11, 2008

Anyone know if you can place a shortcut on the desktop using VBA code?

View 9 Replies


ADVERTISEMENT

Shortcuts To Macro With VBA

Jan 28, 2012

Macro2 is in ThisWorkbook.

Code:
Application.MacroOptions Macro:="Macro2", Description:="", ShortcutKey:= _
"d"

How to do the above when this workbook is not active workbook.

View 9 Replies View Related

Add Shortcuts To My Existing Macro

Apr 28, 2009

I have a routine that by clicking one button, that calls a macro, that currently opens Excel, or Word, or WordPerfect. The following macro uses a Case Statement looking at what the extension is, such as for Excel . . . xls

I have added a case statement for a shortcut . . . exe

View 4 Replies View Related

How To Get Rid Of Duplicated Shortcuts On Right-click

May 17, 2009

I've created a calendar in VB following the instructions in this link - [url]

The calendar works fine but the problem I've got is I've got unwanted copies of the shortcut when I right-click. If you scroll down the URL, right at the bottom in blue is a paragraph that describes the problem and how to get rid of it. I've tried this numerous times but the duplicate entries keep re-appearing.

I've attached my workbook in the hope that any of you experts would be so kind as to take a look and offer any help or advice on how to fix this problem?

View 10 Replies View Related

Find And Edit All The Shortcuts

Jan 3, 2007

Is there a way to find and edit all the shortcuts I created in one (and in more then one) Excel spreadsheet?

View 2 Replies View Related

Keyboard Shortcuts For Existing Macro ?

Dec 30, 2008

Some expert users can unhide a sheet in a worksheet which is protected by password. But I don't want to place a button in the worksheet for everyone to see and wonder what it's for. I can record a macro and assign a keyboard shortcut but I can't do it it with existing macros ?

View 3 Replies View Related

Shortcuts For Moving Tabs To Different Files

Mar 5, 2013

Shortcuts for moving tabs to different files. A copy of the tab, I mean.

View 1 Replies View Related

Creating Keyboard Shortcuts In Excel

Apr 24, 2012

How can I create keyboard shortcuts in the easiest way.

E.g.: I would like to create my own shortcut for "Merge".

View 6 Replies View Related

Excel 2010 :: Reset Keyboard Shortcuts

May 16, 2012

unknowingly i must have deleted some shortcuts via VBA code.

now, the shortcut key (excel 2003) Alt+Insert+Row works!

But, Alt+Insert+Column does not! this works in my colleagues computers which also have Excel 2010.

is there a way to reset all keyboard shortcuts on my computer? i have tried in vain to find a solution but not found one option.

View 4 Replies View Related

Navigation Through Spreadsheet Using Shortcuts - Not Range Names

Sep 10, 2009

I currently have a navigation menu with 9 options however these options are based on Range names that I have set up.

The concern is that if someone deletes the cell that contains the range name, obviously that option in the navigation won't work, nor would you want it to.

However if someone re-enters a cell that you would want linked up with the navigation there's a lot more action involved.

What i'm looking for is a macro that can be used through a button, Idealy i'd like the macro to search through column "B" and look for key labels (ex: "Ground Floor", "1st Floor" "2nd Floor" etc.) and have each button set up for it's respective search data (ex. Ground button searches only "Ground Floor")

View 10 Replies View Related

Set Desktop Background

Mar 28, 2008

Im designing a desktop background for my office, and want to roll it out once complete. Rather than trying to email the image out and get people to do it manually, is there anything in vba i can do to assist in this? I know its asking a bit much, but ive been surprised in the past with how versatile vba is! (i.e mapping network drives). I asked the IT guys to do it over the server, but they started ranting about screen resolution, priority of other jobs etc etc.

View 2 Replies View Related

PO Status Sheet On Desktop

May 14, 2014

How can i link my PO status sheet on desktop to alert material delivery date.

View 2 Replies View Related

Change Desktop Icon

Dec 4, 2008

I was wondering how I could change my desktop icon for one specific workbook to something other than the excel icon. I saw the below link (2nd tip) but that changes the icon for every file of a specific file type. I just want to change one specific file's icon on my desktop to something custom, like a clipart picture of my choosing. I also know that this can be done with shortcuts, but I need it to be changed on the original file. I tried using the IconChanger program, but the icon stayed with the file name so if I did a "save as" or emailed the file, it disappeared. I want it to stick with that file for good, or any file I duplicate from the original, and work on other computers as well.

View 2 Replies View Related

Make Folder On Desktop

May 15, 2009

I'm trying to create a folder on the desktop and save the activeworkbook in that folder. Since other users will use this I dont know the exact path. However I'm using this function below to tell the script where to find the path. Everything was working fine till I started to make the folder can someone point out what I may be doing wrong?

View 5 Replies View Related

Find Any Ones Desktop Folder

Jun 3, 2009

I am having an issue with trying to find anyone's desktop folder. I'm trying to write a path to the desktop but once again the desktop is different on every computer. The problem line is in red.

View 8 Replies View Related

VBA To Open A File On ANY Desktop

Oct 16, 2009

I am sending this workbook out for several buyers to use. Part of the macro opens a workbook on their desktop named "Backorder List.xls" and copied data to it. The problem is, the way it is written, I have to go around to each buyers computer and edit it so the vba is looking in the right directory for the file. Is there any way to modify this so that it will open the file "Backorder List.xls" no matter who's desktop it is on?

View 7 Replies View Related

How To Check For Folder On Desktop

Apr 26, 2012

Using VB/VBA how do i check to see if a specific folder exists if not than prompted to create yes/no. Folder to check should be named Loader Files?

View 3 Replies View Related

Launch A Desktop Shortcut

Apr 6, 2008

I have a lot of shortcuts to movies for my 5th grade students which won't work. I can launch direct file names but not shortcuts from within excel I can click on a cell to launch a direct file like this = "C:Program FilesOfficexpOffice10winword.exe" /n "c:mode.doc" but if C:modeSC.doc" is a desktop shortcut then it opens winword but not the document.

I get " document name or path is not valid" from within winword. But if I go to drive C and click on the shortcut, it opens winword and the ModeSC.doc which is a 1 KB shortcut.

View 9 Replies View Related

Change Desktop Excel Icon

Dec 1, 2008

I was wondering how I could change my desktop icon for one specific workbook to something other than the excel icon. I saw the below link (2nd tip) but that changes the icon for any file of a specific file type.

I just want to change one specific file's icon on my desktop to something custom, like a clipart picture of my choosing. I've seen it done with certain companies changing the internet explorer shortcut icon linked to their webmail, changing it to their logo.

HTML http://www.windweaver.com/w95tips3.htm

View 4 Replies View Related

File/Send To Option Is Available On Laptop But Not On The Desktop

Dec 23, 2008

I have Excel 2002 installed on Desktop & my Laptop. The Send To option is available on my Laptop but not on the Desktop.

View 4 Replies View Related

Copy Database File And Save To Desktop

Nov 13, 2008

Let's say I have a database called testTemplate.mdb in c: which is a template-like database where i import data to. Is there a way for me to copy the testtemplate.mdb and past it to my desktop with file name test.mdb. I don't want to copy any data from the database, just the table's + queries. I would like this to be done via a macro... In order for me to execute other macro's to copy data from excel to that test.mdb file on desktop.

View 2 Replies View Related

Copy Selected Data To Workbook On Desktop..

Oct 13, 2009

As the buyer edits orders, I have a macro which pulls out all the parts with changes and puts them on a sheet named "Changes" in the attached "Sample" workbook. Since the buyer will do dozens of these edits a day, I'm trying to create a simple way for them to create a list of parts they may want to try and buy from another source.

I would like to add a macro that would open a message box telling the buyer to select the parts they want to copy. They could select whatever rows they want to copy to the "Backorder List", and select "OK" or hit "Enter", and the macro would open the workbook named "Backorder List.xls" on their desktop, (mine is located under "C:Documents and Settingsjerry.hutchesonDesktop"), and copy the selected rows to the workbook, then save changes and close the "List" workbook. It should only paste the values, to preserve whatever formatting is in the book being copied TO, and it should copy below any data already in the workbook.

To make things even more difficult, the macro would also need to copy the Vendor # and PO # from the top of the "Sample" workbook, (cells B2 and B3 respectively), and enter that data beside the other data just pasted beside the parts data in the backorder list. (I have entered sample data in the backorder list to show what I mean.)

View 2 Replies View Related

Display Particular Excel Cell On Desktop Permanently

Jul 11, 2012

Is it possible to display a particular excel cell (for example cell A1) on Desktop permanently?

If yes then - HOW ?

View 4 Replies View Related

Reading Remote Desktop Current CPU From Excel?

Sep 17, 2012

I need to find a way to collect current CPU usage of a specific application on a remote server or the top applications that are using the most of the processor's time on a remote server?

View 7 Replies View Related

How To Get Remainders Popup From Excel Sheet Or Workbook On Desktop

Jun 5, 2014

My query is,How to get any type of remainder from my excel sheet/workbook on my desktop.

View 2 Replies View Related

Save Workbook To Desktop If File Doesn't Exists

Sep 22, 2009

I'm having a slight problem with this script. What I'm looking to do is before the workbook is closed is check to see if the workbook already exisits on the users desktop if it doesnt then save it to the users desktop. if is does exists then just exit the sub. Here is what I have so far but for some reason it kept displaying the aleart message that the file already exists and wants to save it again.

I just added the displayalerts = false in but the script still does not know that file already exists. So when the file is closed it keeps saying file has been placed on your desktop.

View 3 Replies View Related

Send A File By Email Versus To A Local Desktop

Jul 13, 2007


Case "TD"
strfilename = "\TomsblackibmTomsProposals" & strfilename

I would like to send this file by email if possible instead of to his computer. The user recently went from a desktop "in the office" to a laptop "all over the place".

Sub Save_and_SaveSalesman()


Dim strPath As String, strPath2 As String, CurrPath As String

Dim WB1 As Workbook
Dim WB2 As Workbook

Set WB1 = ActiveWorkbook

'First thing, save my work
WB1.Save

CurrPath = WB1.Path

'ASSUMING THAT C6 and O3 are BOTH in WB1
'move this line HERE: only do this once, and concatenate in the Select..Case later
'doing thsi inside the Select..Case pulls values from WB2, which might cause errors.............................

View 9 Replies View Related

Unprotect ALL Sheets, Create Folder And Save Copy On Desktop

Oct 23, 2007

I have a workbook which consists of 28 worksheets, all of which are protected, and are running on a code which automatically keeps all sheets at "unlocked cells" in the selection field. The sheet is also password protected for write-access…

I would like a Macro, or some sort of code, that when activated… it unprotects ALL sheets (which use same password), creates a folder on the users desktop, and saves a copy of the document in there… entitled "copy of {filename}" It must also remove the "write access" password…

View 9 Replies View Related

Increase Invoice Number And Save To Desktop As PDF Using Cell Data For Filename

May 15, 2014

Our business has a spreadsheet set up for invoicing. A Macro has been created to increase the invoice number, save to the desktop as a PDF with a file name taken from the cells

This is working on my colleagues mac but when we've loaded onto my computer it errors, when I debug I am getting the following error:

Sub Macro3()
'
' Macro3 Macro
'

'
Range("g10").Select
[g10] = [g10] + 1

[Code] .......

View 2 Replies View Related

Macro To File/Save As "Numbers As Of [today's Date]; On Desktop

Feb 17, 2009

I'd like a macro to have the workbook save as

Numbers as of "today's Date"

and then close that workbook.

I already tried the following...

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved