suppress

Hi All, I am pretty amateur at Excel VBA, so please bare with. I have an excel workbook, this contains lots of worksheets with live data in SQL. The issue I have, is each worksheet is set to data refresh every 5 minutes, independently. Sometimes when it refreshes, it will give an error about...

Hi I have these formulas I am using to plot my charts to keep track as the data expand and shrink . =Offset(DataSheet!$B$2,,,CountIf(DataSheet!$B$2:$B$12,"<>")) =Offset(DataSheet!$C$2,,,CountIf(DataSheet!$C$2:$C$12,"<>")) It's working great just that when the cell B2 or C2 becomes blank...

When embedding a file as a “Packager Shell Object”, I’d like users to be able to click the icon without the sizing handles displaying. Is there any way to prevent the handles from appearing?

I have a macro that cycles thru Excel sheets and performs a print. Some sheets need only certain areas printed, and some sheets do NOT NEED PRINTED AT ALL. The first portion of this is easy enough to handle by using the "Print_Area" name set to the areas to be printed, however, I cannot figure...

This displays the value of a changed cell on the worksheet: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) MsgBox Target.Value End Sub However if multiple cells are selected, an error message pops up: Run-time error '13': Type mismatch I...

I have the following code that deletes rows in a table. When I get down to nothing in the last row and press the button again, I get an error message saying there are no cells found. How do I suppress that message so nothing will happen? Private Sub cmdDeleteRow_Click() 'ActiveSheet.Unprotect...

Hi all, I am calling a procedure in another workbook with VBA. The workbook is already open. I am trying to suppress all alerts with application.displayalerts = False. I added the application.displayalerts in both procedures. But after calling the procedure in the other workbook I am still...

I have a query which shows a zero in phone field even though the table setting are set to short text. I have 5 data bases that are built off of the same template but 2 of 5 are showing zeros in the phone fields. Is there a way to suppress zeros from being shown in the query even though that zero...

Hello I have a start-up menu program (which we’ll call ‘Program 1’) that allows users to enter certain variables, such as ‘Sales Taxes’. The users are then taken to another program (that we’ll call “Program 2’) which will automatically link to ‘Program 1’ and import the assigned values of the...

Dear all, I have a workbook that contains macros and this has been passed out to the user community by being saved in the XLSTART folder (as a hidden file) so when they open excel it is opened automatically in the background and they can use the macros within. This means that a number of users...

Hi, I want to open a number of macro enabled files, and use the data for consolidation. The problem is whenever the file opens the Enable/Disable macro prompt pops out and user action is to be taken. I am trying to consolidate data for around 50 files, without user intervention. How can I...

I've got a control macro in Excel VBA that opens a database in Access, runs an Access macro, then closes the DB, before carrying on with Excel and running off a load of reports. Dim A As Object Set A = CreateObject("Access.Application") A.Visible = False A.OpenCurrentDatabase...

Whenever I try to trace the dependents on a cell that has no dependents, I get a pop-up that says "The Trace Dependents command found no formulas that refer to the active cell". Previous versions of Excel didn't have this popup. How can I suppress it? Thanks