disable

Hi. I have a filter on column "A" with Enable and Disable options via Data validation list. I would like to create a macro that removes all rows flagged "Disable" and place them in rows 200 onwards. So as we disable a row that disable row just goes onto the bottom of the list from row 200...

Been trying to figure this out for a couple of days now - Just need to either disable or make not visible most of the Standard Excel Menus (Insert,Draw,Page Layout, Formulas, Data, Review,View, Developer) when the Workbook becomes Active and then put them back on close or deactive Thanks in...

Hi, Aside from going to the ribbon Formulas > Calculations Options and ticking manual is there any other way to disable a cubevalue formula updating unless commanded to update?

HI I am using Office 2016 I want to disable unprotect sheet or unprotect workbook option when someone open this protected workbook.. how can i do it?? thanks in advance

Hi, I am using an excel document that was created by another person. It has a feature where a comment like window pops up when I highlight a cell. I am not familiar with this feature, but I want to delete it. Since I don't know what it is I can't. Does anyone know what the feature could be...

Hello Guys. I want to disable macro if cell C10 in sheet1 is not blank. It should be active if C10 in sheet1 is blank. I am running macros from ribbon. The macro name i want to disable is "Sub Start(control As IRibbonControl)". It should be applicable to the whole workbook. Thank you.

My module opens a xlsx workbook that can be updated. I want to disable the Close X on the opened workbook so the user must use a userform to close & save the opened workbook. How do I disable the X on the opened workbook from my original module?

Excel friends, I found the thread below to know if "Trust Access Visual Basic Project" is ticked. It works perfectly, but in addition to it, I also need to know if "disable all macros with notification" is ticked. The ideal will be to identify which one of the four is ticked. Is there any way...

Hello, I am trying to create a macro that will enable and disable the ability to save a file unless cells: B5, B10, B38 and F38 have something in them. Any ideas? Thank you!

Hi every Is there a code vba to lock or disable insert new sheet in a workbook?? Thanksssssssss

Hi all I have the following code that I am using to generate a set of discriptive statistics for a set of random numbers by using the . However when I try to loop through the action of refreshing the data set there is a popup. "That says Descriptive Statistics - Output will overwrite existing...

Hello, I am trying to create a VBA code to disable item selection on multiple pivot tables in a workbook. I found the below code online but it only locks one pivot. and I need it to cycle through all the pivots. I tried to change the number to the amount I have but that didn't work. Can someone...

Hello I have a series of programs I've written and each one contains one or more VBA macros. Normally for protection, Excel is set NOT to allow any macros, but now I need to change those settings temporarily. My thinking is that I’d disable the setting not allowing any macros, at the beginning...

I found some great source code from a website (https://www.rondebruin.nl/win/s4/win012.htm) that enables you to disable the user's ability to use keyboard shortcuts. I've used the blocks of code that disable/enable all keyboard shortcuts — not just ones that are listed. I'd like to adapt the...

I am hoping someone can point me in the right direction. I have some simple code that I got help from here and it allows a user to click on a cell then it activates another sheet. How do I stop anyone from right clicking on tab and looking//amending code. I would also like to stop anyone being...

I need to make my document as secure as possible (With VBA as well) I will be distributing it out to users, but nothing is stopping them from taking it and walking out the door and giving to someone else. Although I know Excel isn't the most secure and isn't meant to, but I want to make it as...

I can't find how to disable the notifications for the new Thanks / Quotes / Likes feature. Particularly the email notifications. I can live with the notification area in the web browser. But I don't want the emails.

Hello All, I have this challenge here: i wanna find out if what i am thinking is possible. Then after that i need help with it. So i have a textbox called txtCurrentUser and in this textbox i have username in it. Now i wanna write a script to look at the txtCurrentUser, counting from the left...

could anyone tell me why? and how to enable it?

Hi all, I have a simple macro that is attached to an active x control command button. The macro simply deletes pre-arranged unecessary cells so that a sheet can be printed efficiently: Sub delete_specified_columns() Sheets("Sheet1").Range("B:C,E:F").EntireColumn.Delete End Sub Here is an...