have a pain constantly entering passwords to open workbooks, is it possible to assign passwords to a particular short cut so if for example if I hit CTRL J it will automatically enter the password jabgat2009 and open the workbook- no big deal just if someone know of the top of their head
View 9 RepliesI have several macros where I have assigned keyboard shortcuts, as below. Yet they don't work.
Sub My_FastCleanup()
' My_FastCleanup Macro
' Keyboard Shortcut: Ctrl+Shift+M
-macro stuff-
End Sub
I'm trying to assign a shortcut to a macro I wrote in VB. However, when I go to Tools->Macros->Macros, none of my macros (whether coded in VB or recorded) have the "Options..." button enabled, so I can't assign the macro. This happens whether I use Excel 2003 or Excel 2007. The file is not readonly and I have tried the various levels of macro security. I have VBA installed.
View 5 Replies View RelatedThis is my input for password prompt:
Sub CommandButton1_Click()
Dim wSheet As Worksheet
On Error GoTo ErrHandler
Currently, my excel is protected with a password "PSWD" when users open the file. In my vba script, I have a function that can unprotect my excel without any password input box to the users. This method is to unprotect the file and allow users to do any formating columns and rows tasks, such as add or delete cells. After users finish their job, the file will be protected back. The function is such as below:
Dim wSheet As Worksheet
For Each wSheet In Worksheets
Application.ScreenUpdating = False
If wSheet.ProtectContents = True Then
wSheet.Unprotect Password:="PSWD"
Else
My questions are:
1. How I can create a hidden sheet that has one cell populated only?
2. How can I assign the password that the user enters at the "TextBox1" (first code) to a cell of of the hidden sheet? Do I have to modify the first code?
3. For the second code, how am I going to assign the value to at the wSheet.Unprotect/Protect Password:="..." with whatever the user has previously chosen as a password that refers at the hidden sheet?
When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.
View 11 Replies View RelatedI have a spreadsheet, which has certain worksheets that are password protected. I need to make changes to some of the formulas, and the VBA modules, however I cannot remember the password!! Is there a way of identifying the password??
View 3 Replies View RelatedI am havng problems with the belwo macro code -
Range("G7").Select
Selection.Copy
Workbooks.Open Filename:= _
"Q:PublicPAYMENTS Q&RREPORTSSuspense Activity BUSINESS2008 - Suspense BUSINESS - Activity Reports2008 Avon.xls"
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
When i open the workbook it requires me to insert a password, i tried to type this but excel will not follow keystrokes, i then inserted the password in cell G7 which i then copy and paste, which you can see the copy at the beginning of the macro.
Is there a way where you can get it to insert the password so i can open the workbook in a macro.
What im trying to do is save 26 suspense spreadsheets by just clicking on a macro.
I have a sheet that is password protected. I have this code attached to a command button. It will unlock the worksheet, autofilter it, print it, unfilter it, and password protect the sheet again. However it is protecting it without a password. I need to have it protected with the password so that someone will not be able to just go to tools to unprotect the sheet.
Private Sub CommandButton1_Click()
ActiveSheet.Unprotect "rainforest"
Columns("O:O").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=">0", Operator:=xlAnd
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter Field:=1
Selection.AutoFilter
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True
End Sub
When i have an excel sheet opened and hit ctrl +f the find replace window displays. I want to add a button on spreadsheet that when i click on it, the find and replace window appears, I can not figure out how to do this. I tried using .onkey
View 8 Replies View Relatedi have tried using the letter M as a shortcut key (because it is to activate a "Move" function) but unfortunately it doesn't work. I gather from this that not all of the keys are available as shortcut keys presumably because they already have function.
Is there a way around this? and/or is there a list somewhere of the available shortcut keys?
Need way to list the active shortcut keys? I know there are manyy lists of the desfault shortcuts, buit I'm trying to generate a list of the curreently active shortcut keys & what macros they tie to. I have a vague recollection that someone had a VBA means of doing this, but I cannot find it in the forums I've searched.
View 2 Replies View RelatedCan I have shortcut key go to sheet, example when i click in cell (BU1) - automatic go the sheet bu1.
View 2 Replies View RelatedIs it possible to launch a program through desktop shortcut with VBA? I have the following code and it is giving me an 'Invalid procedure call or argument' error
Edit: Typing the string into the Run command works fine.
Dim objWsh As Object, _
strDesktop As String
Set objWsh = CreateObject("WScript.Shell")
strDesktop = objWsh.SpecialFolders("Desktop") & "Wildfire 3.0.lnk"
Set objWsh = Nothing
Shell strDesktop, vbMaximizedFocus
I have an Excel add-in that makes use of an Application-level event handler to detect when workbooks are activated / deactivated, and adjusts the command bars / ribbon accordingly. The add-in also includes a developer mode, so I have a shortcut key to stop the add-in while running, set the .IsAddIn property =False, and then change whatever settings I feel that I need to.
Problem is, when I run the shortcut to stop the add-in, and then run my shortcut to restart it, my event handling no longer works. I've done some MsgBox testing, and verified that the class module's "Initialize" event gets called, but subsequent events (i.e. WorkbookActivate) go unnoticed.
I'm wondering if Excel will allow me to start an Application event handler using WithEvents, stop it (by setting the class module variable = Nothing), and then re-start the event handling.
The one thing that has always bugged me about Excel is that in order to modify an existing cell, I need to click on the cell and then click in the formula box above. If I want to overwrite the contents of the cell, I can just start typing, but if I want to edit it, I need to use the mouse. It really seems like like Alt-D should move up to this window like it does in Internet Explorer. I can move around Most Windows applications without need of a mouse save for this one area.
View 4 Replies View Relatedi need to create a shortcut (ideally ctrl-z) that will allow me to search column D which has a tonne of street names in it. i need to do a "custom" search and enter "contains" and then have the field on the right be left empty for me to enter what i need to enter.
I want to hit ctrl-z (or a b c d e f g h etc...) and have that blank field brought up for my to enter something to search for and have all those criteria met "custom-contain-?whatitype?"
I've tried using the record new macro function but it won't let me leave the dialogue box open for me to enter my street name.
i hope i explained that well enough....
basically i want to hit ctrl-z and have that custom-contains for column d open and ready for me to search.
autofilter is on. and i am referring to the drop down menu that lists "top 10" "all" and "custom" i want to chose custom and then chose "contains" from the first drop down menu in the dialog box that pops up.
I want to know the short-cut keys for the deleting sheet.
View 3 Replies View RelatedI am looking for a shortcut key or some fast way of getting to the last line of information on a excel spreadsheet.
I currently have order spreadsheets with over 10000 lines used and everyday I need to add more lines and if I have used the Shift+F to locate an old order then I can be say sat on line 40 but my last inputted text could be on line 7000 and I would like to know how I can get to that line without knowing the line number.
The shortcut must take me to the last text entered cell not the last cell on the worksheet.
Simulating the ALT+DOWN ARROW shortcut. I came up with the hereunder code.
View 4 Replies View RelatedI'm trying to make a macro that will help with data-entry. In two columns of each sheet (columns D and J), I'm entering school grade information ("K", "Pre-K", "1", etc, up to "12"). As I move off of each cell with data so-entered, I want to have the entry formated such that "1", becomes "1st", "12" becomes "12th", etc. I've put code into "Worksheet_SelectionChange" and the code works but...
1. The cell value is not changed upon leaving the cell, only after re-entering the cell. So, I type "1" in the cell, move on (the cell value remaining as "1"), then go back to that cell and the value becomes "1st" like I want. So each cell requires entry and then (for example), left arrow, then right arrow, then move on the next cell for data-entry. Since I'm only saving a few keystrokes for each cell, this approach is just about a wash. I need to have the data changed upon leaving the cell. Is there a way?
2. There are 50 or 60 sheets in the workBook and I have to copy that code onto each sheet. Is there a way to move it to the workBook level? Failing that, is there a way to ease the process of pasting that code to each of the sheets?
The following macro works when I run using Alt+F8+Enter
The macro also works when it is linked to a button on the worksheet.
However, it does not work when I try to use the keyboard shortcut Ctrl+Shift+P.
I've tried adding the shortcut key code into the macro -- still doesn't work.
I've tried changing the shortcut key to a different letter
I have data in every other row in a column from rows A1 to A12455. I would
like to know if there is a keyboard shortcut that takes me directly to the
last cell (A12455) in the column that has data in it.
I'm copying a lot of tables and charts etc in Excel to paste into PowerPoint. And I'm using the mouse to go into Past > As image > Copy as image
I then get asked a question that I need to hit the enter button to answer.
I'd like to make a shortcut for this. Is this possible in VBA?
-------
Using Excel 2007 & Vista if that matters
I use the Paste Value shortcut button that I've added to my toolbar in Excel. Just as regularly, I also need to do a Paste Special, Values Only with the Transpose option selected. Is there a way to create my own shortcut icon and build code to do this?
View 9 Replies View RelatedI want to know the shortcut key for to move one sheet from another sheet without using mouse.
View 3 Replies View RelatedI want to know a simple shortcut for display what value is being used in a formula.
for example D3+3=5
I want in the formula bar by using the short key I can see 2+3=5?
Is there a way to put a hyperlink in a cell using a shortcut? In my case i have names in column (last name, first name.pdf). This naming convention is the same as the file folder i am linking this cell to. Instead of right-clicking on the cell for all 600 names and "insert hyperlink" and button down to the file, is there a better more faster way to do this? Say all the names 1-600 are A1:A600.
View 4 Replies View RelatedI have a macro stored a module at Personel workbook and i am using personel workbook as a hidden one. when i assign a shortcut below macro it is not working but whrn i am press F5 at VBA Editor it is working.
Here is the code:
Code:
Sub Transferdata()
On Error GoTo err1:
Application.DisplayAlerts = False
[Code]....
I often find myself moving from one sheet in a workbook to another over and over. I wanted a shortcut that moved between the last two sheets selected.
Similar to how Alt+Tab works with windows.
Does anybody know a keyboard shortcut or if not is there a macro that could be added to perosnal.xls that would mean i would aways b able to switch between two sheets quickly.
I am unable to create a macro and later go back and assign a shortcut key and run the macro.
View 9 Replies View Related