disable

I am Using a Forms Control button to run a macro. I would like to have the Button disabled till certain requirements are met. How can I disable the button. It is called Button 6 I have tried the following code but the button still works as normal even though the sheet is protected...

OK excel guru's, I have a MsgBox that runs when I open the workbook template telling the user to paste previous days data in the prev day worksheet before proceeding. What I want is to permanently disable this MsgBox after selecting OK so once the user has saved the file under the new name it...

Hi, I have a long ListBox and I have to scroll the UserForm to get to the bottom of the ListBox. Problem is that when I scroll down the focus is moved to scrollbar and when I click the bottom value on the ListBox the focus moves onto the ListBox and scrolls all the way up again. I would very...

This works very nicely https://stackoverflow.com/questions/26392482/vba-excel-to-prompt-user-response-to-select-folder-and-return-the-path-as-string Does anyone know if there's any way to disable the Tools Button ?

First, thanks to mole999 for the help with the first phase of this. I thought I'd be able to use the principles to implement the next phase, but my limited VBA knowledge and research hasn't been enough. I am trying to have cut, copy, and paste inactive for most users, but if the user enters a...

So I have been digging the web for a while now and I can't find the best way to handle the above challenge yet. Can it be possible to disable all the menus except the control box items as indicated in the header of this thread? Regards

Hi, is there any chance to disable Snipping Tool to prevent users to snap the data and print it? Thnx

I have a person that gave me their spreadsheet which they use for manufacturing production. At the start of a shift, the shift supervisor presses a "Start of Shift" button. They asked me to place an autosave macro in there so it backs up throughout the day. I put the following macro in: Sub...

Hi, I would like to disable a shape as button to run macro after first click. Is this possible? Thanks

Hello, Im have a workbook that all sheets are always set to be protected and I want cells A3:A130 to be able to edit if date & time in cell C1 is greater than the date & time of NOW so C1<NOW otherwise A3:A130 is not editable. any suggestions is greatly appreciated.

I have a macro embedded shape ("Group 12") on my worksheet that I wish to code to disable the macro associated to it. I know I have to use the Shape.OnAction property, but I'm unsure on the code to apply it to the shape. With Activesheet shape.group 12.onaction = "" End With The line in...

Is it possible to prevent users from adding the autofilter to Excel?

Hey guys:) I have a script that runs and closes on it's own, the problem is that sometimes i get this alert 'Want to save your changes to '***File***'? Because of this when the script closes on it's own it does not close properly. Is there any way to disable this alert message so that it just...

I stumbled on an oddity while experimenting with lightweight objects in vba that I thought maybe would be worthwhile sharing .. Not of much use but, interesting nevertheless. I discovered by accident that when a runtime error occurs while there is a lightweight object in memory, Macros get...

How do I disable alt-f11 to prevent users accessing vba editing

Hi, Very small issue but it annoys me...if I type a password in correctly, a new book opens, which I then have to close. I can't see anywhere in options to disable this...can it be (disabled)?

Hi I would like to use a pop prompt to disable a particular sub within a module from running? The prompt would appear on opening of the workbook. If the user clicks "No" this would disable the sub from running. Is this possible to achieve? Many thanks

I've got a couple of files posted on a shared drive, so multiple folks can access them. One (Schedule) has code to save and close after 30 minutes, since folks are prone to open and then walk away from their desks. It works fine. But, when I tried to use the same code on the second file (MDL)...

I have searched my issue with no success so far. Hoping someone can point me in the right direction. I have a file with many checkboxes. For example: checkbox1, checkbox2, etc. I would like to check any checkbox and uncheck others at the same time. If checkbox1 is already checked and I click...

Hi All, I want to disable all type of any error like some OLE/DDE message or any debug error pop up window in excel. Can anybody tell me , if this possible if yes, than What is the code for same. Thanks in advance for your valuable suggestion. Regards, Rajender