Excel 2007 :: VBA Disable Compatibility Alert

Feb 27, 2014

Currently I am working on a workbook where I am using a Save As VBA to create a folder and rename the file. The following code seems to be working fine so far with Excel 2007. Is there a way to confirm that it will work with all other versions of Excel and that my DesktopFolderPath String will work on all users machines?

In addition to these concerns, I am trying to avoid any Runtime Errors and currently, the Compatability Alert is the only thing I can see that is creating one. When it displays, in the event the user is unsure what to do, as most of our field staff is, and they select "Cancel" it displays the error Run Time Error.jpg. Can the Compatibility Alert be disabled? If so where do i add it in my code.

View 3 Replies


ADVERTISEMENT

Excel 2007 :: Saving Worksheet As New XLS File Without Compatibility Checker

Apr 24, 2013

We are using Excel 2007.

I have a macro enabled spreadsheet and I need to save one sheet into a new file that is in xls format. I can do that --- is there anyway to suppress the Compatibility Checker box to make it that much easier?

The new file will not have macros as will just be a data in rows and columns so compatibility. Interesting is the compatibility checker box says there are links to the original spreadsheet, but I can't find them in the connections menu.

View 2 Replies View Related

Excel 2007 :: Any Way To Call Security Alert To Enable Macro

Jun 28, 2012

I'm trying to find out if there is a way to call the security alert to enable a macro. Let me explain...I was working on a sheet with a macro that I hadn't enabled yet. After working for awhile the option to enable it was gone and I found that I had to close the fine and re-open to enable the macro. I'm wondering if there is a ribbon or short cut icon to put in my access toolbar that will give me the option to enable/disable the macro. Seems strange that in 2003 I could to this, but in 2007 I have to close the file.

View 3 Replies View Related

Excel 2007 :: Security Alert - Data Connection Message Every Time?

Dec 20, 2012

I open a spreadsheet or workbook that has links to other workbooks I am notified by the message bar that content has been blocked. I click Options > Enable this content > OK. Even if I don't make any changes I'm prompted to save changes when I close the file. If I hit Yes or if I hit No, I will still be prompted to enable content in the message bar the next time I open the same file.

I have changed the External Content settings in the Trust Center to "Enable all data connections (not recommended)" and "Enable automatic update for all workbook links (not recommended)" but I still get the messages.

My Message Bar is set to "Show the message bar in all applications when content is blocked" because I read on Microsoft KB that the other option of "never show information about blocked content" will still block the content, just not tell you about it, which doesn't fix my issue.

The files I'm opening and the files linked to and from them are all on the same shared drive on a file server in the office. Is there a way to tell Office '07 that our file drive is a trusted source by default?

View 2 Replies View Related

2007 Compatibility

Jun 29, 2007

I have downloaded Excel 2007 as a trial on to my computer (with Excel 2003 in another directory), when I load an excel file developed in Excel 2002 (containing macros) and try an open it with Excel 2007 the message "This workbook has lost its VBA, ActiveX controls and any other programmability-related features" - no problems in Excel 2003

My operating system is XP SP2

View 9 Replies View Related

Compatibility Between 2003 & 2007

Dec 29, 2009

I would like to send a .xls file created in Excel 2007 to a user who will work with this file on a PC that runs Excel 2003. Will they be able to open and use a file created in a newer version of Excel?

View 5 Replies View Related

Compatibility - 2007 Vs 2003

Nov 30, 2006

I want to install the new Office 2007 onto my computer.

Will my existing spreadhseets be work with the new version?

But most importantly....If I make a spreadhseet with VBA code and send to to a user with the Office 2003 version - will it still run OK?

View 5 Replies View Related

Excel 2007 :: Disable Insert Columns / Rows Only

Mar 1, 2012

I am looking for a way of allowing users to edit the existing cells at their will, but simultaneously disabling the option to insert/ delete columns or rows.

By enabling Sheet Protection, I cannot find a way to do it. Can I?

I am on MS Excel 2007 by the way.

I found the way, just unlock all cells in Format Cells, Protection Tab. Then Protect sheet and de-select what you want to disable.

View 1 Replies View Related

Audio Alert: Alert For When Range ("C4").select Is >=1000 Alert Ring

Dec 7, 2008

I just discovered VBA coding today and was wondering if I could use it as an audio alert. I found a couple examples online but don’t understand the coding language of excel. I have a feed link from my trading platform to excel that feeds in live data. What I would like to do is have an alert for when Range ("C4").select is >=1000 Alert Ring.wav and when Range ("C4").select is <=-1000 Alert Chimes.wav.

View 5 Replies View Related

Excel 2007 :: Clicking On Cell Auto-selects Cell Next To It - Cannot Disable

Nov 16, 2010

Whenever she clicks on a cell, the cell to the right of it is also selected. When she tries using tab to move to a new cell, she can only move between the two selected cells. Same with using the enter key. As such, it is extremely difficult for her to modify only one cell, since she always has two selected.

The F8 key, as well as Ctrl+F8. However, pressing the F8 key only adds more cells to the autoselection, and Ctrl+F8 allows her to select one cell, but also highlights the cells around it, and when we tried to select other cells, every cell we clicked stayed highlighted.

Additionally, sometimes when she clicks a cell, it will just select that one cell. Click it again, and the problem is back. I haven't been able to determine any patterns to this behavior, and I know there is no problem with the input (the keyboard and mouse are standard-issue in our lab, and we keep them well maintained).

View 8 Replies View Related

Macros Crahes - Alert Alert - Shut Down All Systems

Mar 27, 2007

Each month I get a report that I process using a macro. The problem is that each month the name of the file changes and is different. When I run the macro and it crashes I have to de-bug by going through the code to change all references to the file name from the the previos run and change to the latest file name and then re-run the macro. There must be a better way.

I would like to learn the code that sees the open book and then refers to it for the run.

What is the best way to do this?

View 6 Replies View Related

Disable Menu Items In 2007

Jan 24, 2008

How can I disable the SAVE and PRINT options under Office Button, in excel 2007??? I've tried a macro that I used in 2003 version, but it not works (problem: "File" menu)!!!

View 2 Replies View Related

Creation Of Audible Alert In Excel

Jan 28, 2013

How to create an audible alert in XL. To be more specific, I would like the system to alert me on various due dates for the data entered. The key filed is the DATE. The due dates for re-validation could be between 07 days to 3 years.

View 2 Replies View Related

Alert When Date Expires In Excel

Mar 24, 2014

Book1.xlsx

In the attachment you will see I have two tabes called License-Equanet and License-Dell, on each row i show an expiry date.

The first sheet is called 'Due to Expire'. One month before an expiry date is reached in the licenses tab I need the information in that row to appear in the 'due to expire' tab. This will then alert me one month prior to the license expiring.

View 1 Replies View Related

Display Alert On Excel Start

Sep 12, 2008

I have created a program to display an Alert based on a Date. I have this program enlcosed in the Workbook Open event. I need to popout this alert everyday, everytime EXCEL starts on a computer.

I had something in my mind though - I thought of plonking this program into the Workbook Open event of the Personal.xls workbook for a computer and thereby I could have achieved my requirement of popping out this alert everytime when Excel starts. However, there is one problem here. Every 3 to 5 days the dates in the workbook are going to change and I do not want the user to tamper with Personal.xls on his / her computer.

So I gave it a second thought. I created a shortcut of this workbook and placed it in the XLSTART folder for a computer and now the problem is - it opens the workbook itself rather than popping out the alert whenever Excel starts on the computer. So this would not work too.

Is there any other way I can make the alert pop out everytime I start Excel on a computer ?

View 9 Replies View Related

Excel 2010 :: Creating Sound Alert

Feb 23, 2012

I would like to create a sound alert if the answer to an "if" statement is false. I am using Excel 10. Can it be done, and if so, how?

View 5 Replies View Related

Enable/disable A Criterion WITHIN An Array Formula (2007)

Jun 13, 2009

I have collected some data from survey respondents, and I have the following array formula:

=MIN(

IF($C$1:$C$400="happy",

IF($G$1:$G$400="tall",

IF($H$1:$H$400="american",

$F$1:$F$400

))))

What I'd like to do is make the 3rd criterion -- $H$1:$H$400="american" -- dependent on whether the string value in cell A1 ("Evaluate Americans only?") is "yes" or "no".

Because, my actual situation is considerably more complex (see below), I'm looking to insert a test within the MIN array formula to check the value of A1, and calculate the answer accordingly.

I'm aware that I could theoretically create two array arguments (one with & one without the American test), and place them inside an IF function that tests the value of A1. However that isn't practical for my real-world situation...

I occasionally see array formulas with all sorts of symbols that I don't really understand in the array context (such as * and | and . ), and I'm wondering if one of those magic symbols might be the doorway to my solution.

View 5 Replies View Related

Set Audio Alert That Triggers As Excel Cell Value Change?

Jun 9, 2005

I would like to add an audio alert to a spreadsheet cell whenever it changes to a specific value?

View 4 Replies View Related

Auto Filter Compatibility

Aug 3, 2006

I have a spreadsheet created in Excel 2003. All the non-entry cells are locked. When I protected the sheet I ticked the option for the auto filter to work. The problem is when I send the spreadsheet to my user - she uses Excel 2000. The auto-filter buttons do not work for her but they do work for me. Is there anyway round this? I need to have the sheet locked (apart from the entry cells) but I also need the auto filter function. I've attached the spreadsheet I'm talking about. The protection password is set to "password"

View 2 Replies View Related

UDF Compatibility Between 2003 & 2000

Aug 17, 2006

I have an activity recording tool created in Excel 2003 which works perfectly (ish)
However when some of my colleagues use it on machines running Excel 2000 it falls over at the following definition

Dim dlgFile As FileDialog

this is part of the following sub routine

Sub doCopy()
Application.ScreenUpdating = False
Call Archive
Dim dlgFile As FileDialog
Dim rv As Long
Dim sCreated As String
Dim sClosed As String
Dim wsThis As Worksheet
Dim wbkAOM As Workbook
Dim sThisCol As String
Dim aAOMCol As String
Dim strDate As String
Dim wsCore As Worksheet
Dim wsDiverted As Worksheet
Dim iRow As Integer
Set wsThis = Application. ActiveWorkbook.ActiveSheet
Set dlgFile = Application.FileDialog(msoFileDialogFilePicker)
dlgFile.Title = "Select AOM Sheet"
dlgFile.InitialFileName = "*.xls"
rv = dlgFile.Show.......................

View 5 Replies View Related

TRUNC Dates For Vlookup Compatibility

Jul 7, 2008

I have a two sets of data, from two different programs (Excel and Access), were the dates are not compatible with each other in vlookop in excel. The problem seems to be in the decimals of the datevalues, which I have been trying to solve the problem in various ways. The only thing I can get to work is to trunc the dates to get rid of flawed decimals somewhere in the end of the datevalue.

My question to you is how many decimals I should use when I trunc in order to keep the right date in the format of (yy-mm-dd hh:mm). So far, 10 have proven unsuccessful (=trunc(A2,10)), but 8 seems to work. I wonder if I can decrease that number even more and still keep the format above?

View 9 Replies View Related

VBA Code Opens File In Compatibility Mode?

Jan 3, 2013

I have written a macro to loop through files and subfolders to open a specific file for a specific month. I extract the datasets for every excel file into a master template. The code works flawlessly when all of the files have the .xlsm extension. However, I need to open .xls file formats also. When my code opens the first .xls file, named "Staffing Plan.xls" it opens it and automatically makes it "Staffing Plan1 [Compatibility Mode]. I can't open the file in the original "Staffing Plan.xls" file format to read data from. How can I fix this?

View 3 Replies View Related

Disable All Excel Functions?

Oct 19, 2011

Is it possible to disable all Excel functions? not as in disable calculation, but actually make Excel's standard functions not available in a workbook.

My reason for wondering if this is possible is that I would like to write UDFs that perform special actions in addition to the typical Excel functions, but give them the same name as their Excel counterparts... essentially create polymorphisms / overloaded Excel functions.

View 4 Replies View Related

Disable Excel Key-catcher

Dec 1, 2011

I'm actually trying to make a game in Excel, coded in VBS (I know, this is crazy ), and I use the API "GetAsyncKeyState" in order to catch what keys are pressed :

Code:
Public Const VK_UP = &H26
Public Const VK_DOWN = &H28
Public Const VK_LEFT = &H25
Public Const VK_RIGHT = &H27
Public Const VK_DELETE = &H2E

Set oDyn = CreateObject("DynamicWrapper")

[Code] ........

It works perfectly, except when the Excel window is activated (i.e. foreground) : GetAsyncKeyState doesn't catch keys anymore. Excel seems to keep it for himself, and don't share it with the System...

I already tried to disable the Excel DataEntryMode, but my problem's still here... Is there a way to disable this Excel's behaviour, or making GetAsyncKeyState work better ?

View 1 Replies View Related

Disable Save As In Excel

Mar 22, 2007

I need to disable 'save as' in an excel file. I have read some previous topics but I cant understand it. Is there anyone who can explain it to me as detailed as possible?

View 9 Replies View Related

Disable Commands Ribbon Excel

Jun 23, 2012

I have the code that accompanies the attached spreadsheet model that locks the copy, paste, cut, double click and so on, with the right mouse button and shortcut keys, however, the toolbar excel these functions still remain active. How well I block access to the toolbar.

Desable_Ribbon.xlsm‎

View 14 Replies View Related

Excel 2010 :: How To Disable AutoFit

Dec 6, 2011

Every time I type a number too large for a column, Excel resizes that column. This is definitively not what I want to do. I googled a lot and looked at all options, but I could not find a way to stop this behaviour.

how to disable any Autofit initiave from Excel 2010?

View 3 Replies View Related

2000/2003 Formula Compatibility: The Formulas Fields Do Not Populate Data Just #N/A

Apr 24, 2007

When I open an excel 2000 spreadsheet in 2003, the formulas fields do not populate data just #N/A. I can see data just fine in Excel 2003 viewer.

View 5 Replies View Related

Disable Printing In Excel Workbook That Has 3 Worksheets?

Jul 15, 2014

I am trying to disable printing in an Excel workbook that has 3 worksheets. I do want any worksheets to be able to print.

View 2 Replies View Related

Disable Only Close Button In Excel Workbook?

May 16, 2006

Sample code on disabling the close button in Excel workbook?

I tried the Tool -> Protect -> Check Windows method. But, it will disable the maximize and minimize buttons as well. Moreover, it will minimize the workbook.

View 2 Replies View Related







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