activate

I have this code that I cut and paste into a workbook, run and then save and close in a macro free workbook. I am trying to set this up as a macro in my personal file to share but keep getting the error above after the activate line. Any ideas as to why I cannot simply just put this as a...

Hi guys, while I've been using the site for many years as a guest I've only just joined. I must say thanks for all that you guys do in helping complete strangers. Right, down to business. I have a set of hyperlinks on a masterdata sheet and a "cover sheet" with several vlookups. how can I...

Hi all, Macro to activate other open excel file which each time can have different file names. Thank you in advance.

in the before close event how do I write the vba code for this scenario: if the button selected is either SAVE or DON'T SAVE then do activate formula bar (which was deactivated in the workbook open event) otherwise do nothing if button <> cancel then activate uniform bar endif thank you

Hello, i have following Code: 'Quelle definieren Dim AusS As Workbook Set AusS = ThisWorkbook 'noch prüfen, dass die Zieldatei nicht bereits geöffnet ist If Datei_Geoeffnet(Path) Then MsgBox "File blocked!"...

hi want to find and activate cell. Get syntax error dim t as String Worksheets("Sheet1").Activate Range("A1"). Select t = ActiveCell Columns("D:D").Select Selection.Find(What:=t. Activate help!

Hello all, I am calling 3 macros from module using worksheet activate event. My problem is those 3 macros repeating continuously not stopping after running the 3rd macro. What might be the issue? Am i missing anything?

Thank you in advance I need to rite code such that when the button is pressed the next integer is appended to the end of thetable and its square (n^2) and root (SQR(n)) are calculated and displayed in the table. here is what it should look like...

Hi I have a lookup workbook with 50+ sheets of data and I would like to activate a specific work sheet from that workbook if a cell in the active sheet containing a specific value matches the sheet name, Is this possible to do this?

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active - .i.e minimized or hidden behind other windows) My goal is for the user to be able to bring the Excel workbook up with the shortcut key even if...

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active). The idea is that the workbook could be minimized, hidden behind other windows, or visible, and when the shortcut key is pressed, it will...

Hi, I have userforms that open when I click in a cell - the userform has a listbox with terms to select for the cell. The problem is that if the cell is in the same area that the userform occupies the same click opens the userform and selects a value from the list - how can I avoid this - I...

Hi guys, <o:p></o:p> I’m trying to write VB code in workbook A that monitors the next workbook to open (we’ll call it workbook B) and reports back to workbook A whether or not Workbook B is read-only or not. Workbook B could be a VBA enabled or a non-VBA enabled workbook and could be any...

Hello Guys Is there any module macros to activate and deactivate the macros in excel objects(Thisworkbook or sheet)? Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Range(Cells(ActiveCell.Row, 3), Cells(ActiveCell.Row, 25)).Select End Sub

Hello all I have an excel form which has 5 frames and each one is named Frame1 Frame2 Frame3 Frame4 Frame5 When i run the VBA to activate the user form you can see these names Is there a way please to hide the names I have tried Frame1.visible = False But this is not working

I have a worksheet labeled ADMIN that I would like to be seen in the worksheet tabs at the bottom of the workbook. However, I would like a password input to be required if the user tries to activate this tab. Is this possible? I thought potentially have some code in the worksheet activate tab...

I have the following code to insert columns, but for some reason it won't insert them. It doesn't give an error, the macro just stops and doesn't insert: Sub Worksheet_S10() 'Activate Workbook Workbooks("WorkBook.xlsm").Activate 'Activate Worksheet...

I am writing a simple string of code and continue to get an Error that reads "400." I found a thread that addressed this, but thought maybe it had something to do with the code. Sub Worksheet_S10() 'Activate Workbook Workbooks("Workbook1.xlsm").Activate 'Activate Worksheet...

I'm stuck with a simple code that I can't make it work. I have two open workbooks and I would like to activate the other workbook from the active workbook based on a cell value. The idea is to activate and close the workbook that includes the database keep the one with the output. I'm using the...

Fellow sufferers! The 2nd line below fails (run-time error 1004): Set cht = Sheets("Approval (F3)").ChartObjects.Add(0, 0, 300, 300).Chart cht.Activate Why can I not activate a chart I just created?!? BW Peter Bunde Hansen