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


How To Disable Worksheet Functions Within Out Protection

Jun 19, 2009

I have a spreadsheet which has extra worksheets at the end that the user can move around, if they need them.

Then i found out that users were adding there own sheets, so i protected the workbook, but i found out that this stops the user from moving the sheet.

Whats the easiest way probably using code to disable the worksheet functions, ie the ones that appear if you click on the tab (insert,delete,rename,move+copy,select all sheets etc) but still allow the user to move the sheet within the workbook

View 7 Replies View Related

Re-enable Right Click Options, Disable Cut Functions

Sep 30, 2008

I need a macro to disable all cut options (ctrl^x, right click cut, cut button in ribbon above), disable drag and drop, but still allow copying and pasting (the cutting affects cell references). I've already locked the spreadsheet, but users need to be able to input information and paste information in from other workbooks. This code must also only apply to THIS WORKBOOK and not affect others. Please help with a macro for this, as well as where to paste and how to properly configure macro security settings. I'm a big excel user, but this is my first time ever with VB and macros so talk to me like I'm dumb! I've pasted links to the two codes I tried, and I think one of them enabled a macro that affected all workbooks and now whatever code I put in won't save upon re-opening. It's there when I navigate to it, but it is ineffective like it's not even there. In macro security, I've enabled all macros and have the "trust VB programming" box checked. So maybe do some damage control before re-programming. I am getting a new computer in less than a month, but I want to be able to try out the code and have it work first, and I don't want to transfer the harmful code to the new computer.

P.S. This first code allows copying and cutting, but then just disables pasting, which is not what I want. The second one works great, but disables the right click menu altogether, which is no good either. And neither allow for pasting from the outside. And this is for moderate excel users, they won't try to erase the macro. I just need to keep them from making mistakes with cutting.



View 14 Replies View Related

Hide Title Bar / Ribbon - Disable Keyboard Functions And Right Click?

Apr 24, 2014

Below are the codes to hide the objects within Excel, Disable Keyboard shortcuts and disable right click, all are placed in the ThisWorkbook and i placed them in a 'Private Sub Workbook_Open()' function.

'Change 'False' to 'True' to unhide
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False


There maybe simpler ways to do the above i just don't know them, it's just these have worked for me and i have had zero bugs come back from them!

View 2 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 :

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.


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

Convert Excel To PDF With All Functions

Dec 11, 2012

I've made one calculator.

Offertkalkulator Freihandlabor GmbH.xlsx

I want to convert excel file with all functions in PDF.

So I want all functions and formulas that are in excel to work in PDF.

View 4 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

Disable Copy / Paste Into Excel Workbook?

Feb 16, 2014

I Have a spreadsheet in which data is spreading into column A-Z. I would like to disable copy, paste, ^V,^R,^C, ^D for certain columns (Q-U) of the workbook so that user is forced to enter data manually on these columns.

Is there any simple of doing this using VBA.

View 2 Replies View Related

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 View Related

Disable Access To Excel Backup File In VBA?

Oct 7, 2011

Is there some sort of vba code that will stop excel from creating a backup copy of the export file from access?

XLApp.ActiveWorkbook.Close SaveChanges:=True

This code saves and closes the workbook, but it then creates a backup copy. I would like to enter some code so it stops making a backup file.

View 2 Replies View Related

Excel 2007 :: Too Many Nested Functions

Jan 31, 2014

Attached is a small spreadsheet, my problem is I am using Excel 2007 and it only allows me 7 nested functions and I need to do 31.

Nested Function.xlsx‎

View 8 Replies View Related

Excel 2010 :: Sumproduct And Min / Max Functions

Mar 5, 2012

How to add Sumproduct and Min/Max functions? Using Excel 2010

I am looking for the minimum, or maximum number within a range while using the Sumproduct function.


View 7 Replies View Related

One Click UPDATE Using VBA Or Excel Functions?

Jan 5, 2014

Is is possible to Update the master sheet with data from sub sheets in one click? Let us say we have one Master Sheet and Three sub sheets with name A, B, C. I would like to have excel function on Master sheet or Update button on Master sheet by which if i click on that it should copy all data except labels from A, B, C to Master sheets and also while copying one column should get auto filled based on from which sheet the data been copied. For example- If 10 data copied from A sheet on column X should show A, if data is copied from B, it should show as B...

View 1 Replies View Related

Excel 2010 :: Disable Something Like Text Box Related To Cells?

Aug 4, 2014

I am using excel 2010. When I click on cells on one column, something like text box will pop up with information related to that column. How can I get rid of this text box. How to disable this text box which I think it has a link between the text box and cells on that column.

View 1 Replies View Related

Excel 2003 :: Data Validation - Disable Delete Key

Mar 31, 2010

I'm using Excel 2003

Cell D7 - data validation reads as such: It is a List and the source is I6:I7. I have In-Cell dropdown selected. Ignore Blank is not checked.

I now password protect the sheet and only D7 is unlocked. real simple, the person using it can only use D7 and select one of two in the drop down menu.

The problem is, if the user clicks on D7 and hits delete, the cell goes blank. How can I avoid this?

View 8 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

Excel 2010 :: Disable Import Data Dialog Box?

Apr 23, 2012

Is it possible to disable Import Data Dialog box in Excel 2010? I have a web query file. I want to copy its content and paste in a new worksheet under an existing workbook. I have a macro which does that but I get Import Data dialog box when I tried to paste the copied content from test.iqy file to new sheet. The dialog box has

Select how you want to view this data in your workbook?
By default Table is selected, which is fine.

Where do you want to put the data?
By default New workbook is selected. I want to have Existing worksheet selected by default.

Is there a way to set these requirements into vba code and make this dialog box not appear at all?

View 2 Replies View Related

Excel 2010 :: How To Completely DISABLE Spell Check

Feb 28, 2013

We're setting up a test for candidates in an Excel 2010 workbook and want to get a sense of their native ability to spell. We'd like to disable spell check for the entire workbook. I've looked in Options>Proofing, even tried removing the dictionary, but haven't found a way to completely disable spell check from working. Is it possible to achieve? We'd settle for being able to disable spelling within a textbox.

View 7 Replies View Related

Excel 2013 :: Disable Ctrl+Mouse Wheel?

Apr 8, 2014

Is there any method to disable Ctrl + mouse wheel function in excel 2013, actually I want to disable zoom in and out functionality but don't want to disable normal scrolling.

View 2 Replies View Related

How To Control Individual Functions In Excel Chart

Apr 13, 2014

All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also given (60) for the X axis.

Why do the NORMAL bars aren't located on the place they should on the X axis?

For example, the 1st bar (from the left), should be a little more to the right. The others should move to the left.

View 1 Replies View Related

Excel 2007 :: IF Functions With Date Ranges?

Apr 30, 2010

Is there any formula that I can use when working with a specific date range and if someone's birthday falls in that range a certain text or value would be displayed? For example I want to create a spreadsheet for my soccer players and have them sorted into teams according to their birthdays. So if their birthday falls into the following date range: 08/01/05-07/01/07 a U-8 or U-10 would be displayed in the corresponding cell. I tried working with the IF function.

View 4 Replies View Related

General Excel Search Tool For All The Functions?

Jun 30, 2013

Is there any excel-addin which offers function in which you could search any excel function (not just formula) so that you could access any function in a seconds, just like google desktop search for windows.

Right now you could use quick access for most common functions you use and shortcuts for functions in different group. But if there is universal search for all the functions, it is going to be faster for any access!

View 2 Replies View Related

Excel Count Functions Without Deleting Old Data

May 11, 2014

I have the following data. i need to count 5 times "N-TRX1" IN column "D". and returns me input "true/false". but the catch is that i need then to overlook this 5 times and start to count again from the same column without deleting the old data. Can i do it?




[Code] .........

View 4 Replies View Related

Excel 2013 :: Disable Automatically Scrolling To The Top Of Current Cell?

Jan 2, 2014

I am using Excel 2013. I have a spreadsheet that has a lot of very tall cells. When I use the scrollbar to scroll to certain parts of the spreadsheet it will automatically scroll up or down to the top of a cell. So if I want to view the middle of two tall cells that take up the whole screen it will automatically scroll up to the top of the highest cell that I'm currently viewing.

I just want to be able to scroll to where I want to scroll without Excel moving me up or down. I've tried to find answers on message boards but no luck.

View 2 Replies View Related

Excel 2010 :: Disable Default Close Button In Workbook

Jun 3, 2014

How to disable the default close button in a workbook not to affect in my command button close.

I tried already cancel = true but my command button close is also been canceled.

View 3 Replies View Related

Extracting Numbers From Text Using Macro Or Excel Functions

Dec 10, 2012

I am trying to extract values from a text. I used macro to solve the problem. I was able to extract the numbers however i am trying not to extract all of the numbers in text. For example as you can see below, i am trying to get only 22.99 The only unique thing here can be $ sign i believe. I need to put a criteria that selects the number right after $ sign and extracts 5-6 decimals after that.

**work lamp/desk light led;orion8879 final price: $22.99 (store)**
this is the text in a cell and i only need 22.99 not 8879)

View 9 Replies View Related

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