|
My Excel macros won't run any more, even Low security When I try to run my macros that have been usable for years, I tried to run them tonight and got this message. “Macros in this workbook ae disabled because the security level is high, and the macros have not been digitaly signed or verified as safe. To run the macros, you can either have them signed or change ... 19 Jul 2008 23:13
clearing excel memory before saving Excel seems to hold onto its completed macro in the background. then saving the file increases file size by 4.5 mb. Can you code in a macro to run, then clear its memory. User can then save file when ready without increasing the file size. The information only sorts, no new data is added, but file increase 4.... 19 Jul 2008 21:10
Set Cell.Value to the Formated value Hi All - Simple one I think, but I can't connect the dots. Cell.value is a date with custom number formatting. File is saved off to tab delimited text. When reopened in Excel, Excel default formats the dates, as the format didn't stay with the file. Not what I want. How to I get around it? I'm thinki... 19 Jul 2008 21:10
Convert Advanced filter macro to VBA Hi I have this macro to filter data Sheets("Working Data").Select Cells.Select Selection.Delete Shift:=xlUp Range("A1").Select Sheets("Raw data").Cells.AdvancedFilter Action:=xlFilterCopy, CriteriaRange _ :=Sheets("Filter Criteria").Rows("1:3"), CopyToRange:=Range("A1"), Uniq... 19 Jul 2008 17:05
VLookup in VBA? Hi, Everyone - I've been gone for a while, but back now... :) I have a question that I've been going crazy. I'm working on our Payroll Sheet for work, and the situation is the following: On the sheet DATA, I've put together VLookup table with all the employees and their specific data on budget percentages on... 19 Jul 2008 20:09
Using VSTO2003:Excel 2003 appears and then disappears immediately when debugging with VS I got Visual Studio 2003 and Office 2003 on my PC. I created a MS office system project with Excel template from VS 'New Project' dialog without changing or adding any code. Then press F5. I can see Excel shows up, but then disappears instantly. I also tried to add the following code to ThisWorkbook_Open, and set... 19 Jul 2008 15:02
Listbox I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks ... 20 Jul 2008 01:15
One macro changing another I have a macro in the Excel file. I want to change coding in that macro by running another macro. Is it possible? Beth ... 19 Jul 2008 14:00
Switching to a specific worksheet I'm new to VBA and have a sub that creates a new worksheet with the name specified in a input box. I would like to switch back to my original worksheet after the creating the new one and I'm lost. I would also like to switch to any worksheet just by entering the WS name in an input box. Appreciate any help. Than... 19 Jul 2008 12:58
Adding a commandbutton in Excel 2003 How do I add a commandbutton in Excel 2003 and modify its characteristics? I have pasted a commandbutton from the control group and modified its caption. I am not able to change its font name, size or make it bold. Also, how do I attach macro code to it to cause it to execute. I am trying to translate a task given... 19 Jul 2008 18:06
Excel 2007 Chart in VB6 Program I have another thread in the VB group and was told to post to these two groups so sorryfor the multi-post. Ill post there again just in case folks want to follow the thread. So I've had a Visual Basic 6 app (as an EXE) that has worked great for the last 9 years or so. Up until Excel 2003 I have had to make minimi... 19 Jul 2008 11:57
txt-file is in ANSI format or OEM Character format. Hi NG. Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM Character format. Is this possible to save a txt-file (ANSI format) to OEM Character format. -- Best regards from Joergen Bondesen ... 19 Jul 2008 09:54
linking external data hello, how can I link external data (from Access tables) without referring the DataSource to a fixed path, but to the Workbook path by VBA code? Now I refer to a fixed path (e.g. C:\P1) containing the workbook and the mdb files and the workbook refreshes the data external links at the opening, but if the wo... 19 Jul 2008 08:52 |