disabled

Now I get a message that saysCannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." I know the macro works because I can run it out of VBA <macros> and it ran it all worked of the Ribbon a few hours ago. So that leaves "Macros Disabled" as...

For some reason, I get an error message after I add a new worksheet to my workbook. It says "cannot run the macro. The macro may not be available in this workbook or all macros may be disabled" My macro security settings are correct. Any ideas? This is the macro: Sub createNewWorkbook()...

I have code that executes on open. After the code runs, it saves and closes the workbook...which it is supposed to do. HOWEVER, when I disable macros, and try to open my workbook to edit my code, the code still runs, even though my excel settings have macros disabled. What.The.Heck?

I was writing a program and got hung in a loop, so I ended Excel through Task Manager and now I'm getting the message "Because of your security setting, macros have been disabled." I tried going into the Trust Center to re-enable macros, but all the options are greyed out and I can't select...

Hello All, If there is a technique for enabling macros in Microsoft Teams, please tell me. I developed this shift pass-on macro filled workbook, and now my employer wants to upload it to MS Teams, and of course all of the macros are disabled. I searched the Forum here and am surprised that...

Hi, Is there any way to turn on the Clipboard in Microsoft Access when Allow Full Menus is unchecked? There are instances where users copies bits of information from Excel and needs to paste it into fields on a continuous form in Access. However, they are unable to because the allow full menu...

Sir I have created a vba macro in Windows 7 64 bit and that is working fine in my laptop . But when I opened the xlsm file in a 32 bit system the developer design mode is greyed out and all macros are disabled. There is no option to enable them. Kindly suggest how resolve it...

I would like to disable the ability for the user to right-click on any of the sheet tabs in a particular workbook. I ran across a web page that talked about how to do it, using this code in the ThisWorkbook module: <code class="vb keyword"> Private</code> <code class="vb keyword">Sub</code>...

So we finally got Excel 10 rolled out and find that all files with macros are automatically disabled. Except for a .xlsb file that contains copies of macros I had stored in my Personal.xls macro workbook. When I open the .xlsb file I get the option to Enable Macros. However, if I take a .xlsm...

In previous versions of Excel, if I hold down the shift key whilst opening an excel workbook, macros are disabled. Alternatively, if the macro security setting is set to "Disable all macros without notification", macros will also be disabled. However, in the Excel 2106 64 bit version, I have...

Hi, I have a couple of Active X buttons which do not work when clicked, if I use the New Window function (I have a split screen of the same workbook but with different sheets). These same buttons still work fine in the original window. Is there anything I can do to fix this?

Hi all, everything was perfect, today I run several macro (built by me and downloaded) now When I check the table design view option or paste option it is disabled it is happening for any access file I open. I have tried these option (AllowFullMenusAllowSpecialKeys enable design changes for...

Hello All, I have a userform with 3 checkboxes. When userform initializes only one checkbox (checkbox1) is enabled and rest two are disabled. I want when user check(select) the checkbox1 then only other two checkboxes get enabled and when user check again (deselect) the checkbox1 then other two...

this problem is somewhat hard to describe so I made a video of what happens: problem with excel - YouTube as you watch the video notice that when I input something into a cell, excel will become disabled or grey and i have to click the cell again in order to keep inputting. i have had this...

I have a protected workbook, in which users should be able to filter various data points. I have the AutoFilter turned on prior to protecting the sheet AND I select "Use AutoFilter" when I protect the sheet. Immediately after the sheet is protected, everything works. However, if the workbook is...

Hi, I have some problems with my workbook. I have a workbook that I am going to send to employees and it contains macros. Now, if those employees does not know excel, they might disable macros since it states that it is a security threat. However, then all my work with the workbook is wasted...

Hello everyone. I did an internet search and a search on this site before posting this. I couldn't find an answer to my question. I may not have been putting in the correct criteria, though. I have a userform that is pulling information from a spreadsheet. It's for viewing a products...

Hi, May i please ask for help on this excel problem i have? I have 3 buttons, which already have macro's. I need these buttons to only be clickable when all cells have values in them. Note: 9 are dropdown lists and 5 are manually entered. Dropdown: C4, C6, (C14 D14 E14 F14 G14), M8 and M12...

Hello everyone, Need help on this.. Insert & Copy field in right click button disabled in excel.

Hi, I'm having an issue with Excel 2013 disabling Macros without notification when opening a workbook using VBA in another workbook. I've tried all of the obvious security setting combinations but I can't even get a notification to ask if I want to disable macros, they are just automatically...