longer

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 just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?

Hey all, There’s something I was wanting to do with our QC checklist, and I’d like your help with it. Essentially the idea is to have the cells conditionally formatted so that If cell J15= Y the all the cells to the right (M15,V15,AE15,AJ15,AM15 and AP15) will have a red fill until it is no...

I am creating a budget template. I am sharing it with two others but they haven't added any restrictions. For some reason, I can no longer click certain features in Excel (such as add border or font color). The workbook does have a macro which locks each of the three tabs when the file is opened...

Good Morning So I have two sheets. both have Zip codes but on one sheet some of them are 00000,some are 00000000 and some are 00000-000. the other sheet are all 5 position 00000. for them to match I'm using =LEFT(A1,5) and it shortens them all to 5 positions but then Vlookup no longer works...

When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...

Hello The helper or guide for excel no longer appears. For instance in the past I would be typing code and a "helper" would pop up. In a module, If I entered Columns. a drop down box with all the available choices would appear. Or if I entered Columns.Find( the properties needed for each comma...

I am working on a project where I have numerous userforms and each as a date that auto-populates in a text box, well it used to populate. I name the userform a custom name, but when I double-click the userform to view the code, it no longer uses the custom name, but rather defaults back to...

Hi, I am relatively new to Power Query in Excel, I am really enjoying it though and can't believe I didn't pick up on years ago. Anyway, that aside, I've built a number of spreadsheets with a number of queries within each that automate a lot of my reporting and tracking activities. The queries...

Receive an error: "One or more formulas in this workbook are longer than allowed limit of 8192 characters. To avoid this limitation, save the workbook in excel binary workbook format." Workbook contains thousands of used cells. How can I identify the cell that is longer than 8192 characters...

I created an excel sheet that contains all the purchases we've made at Costco. The main thing I was interested in was calculating the total grocery expenditures for each month in 2018. The SUMIFS formula that I had for some reason is no longer working. For reference, I posted a question about...

I haven’t used excel in years. How do I format a cell to be red when the cell is blank. Once something is entered into the cell, the cell is no longer red. Please and thank you.

I'm attempting to enter data by hand into a worksheet. I have selected cells and formatted it to text only. When entering -7.82 dB it adds = and some other nonsense ahead of what I have typed. And I can't remove it. Attempting to has highlighted a Cell blue and Hung me on something as R-click...

Hello Guys I have a formula here. Array Formula Needs to be Entered by CSV. =Max(if(A:A=G2,C:D)) There's nothing wrong with the formula above. It's working perfectly fine. However , I notice that if the column is separated. It will no longer work. Let's say the results I want a max...

So I would like to automaticaaly protect a worksheet if the user is no longer inputg data after 10 seconds. Can this be done?

Morning, Can you be of assistance to alter the following code supplied. I wish to clear contents of the active cell B13 once its no longer the active cell. Have a nice day. ​Sub sbClearCellOnlyData() Range("B13").ClearContents End Sub​

Hi all, Is there a way that I can make a macro to enter a row once 2 cells no longer match? Let's say there is data in columns "A" to "Z". Once the data no longer matches in Column "L", I would like a row added in between. Thank you!

Hi Everyone, This is driving me a bit crazy. It used to be that Excel would repeat the last action I made if I pressed the F4 key. Now it no longer does this. It's not an issue with a function lock. If I press F5 I still get the Go To menu. But somehow F4 no longer repeats the last action...

I am attempting to make it so rows hide/unhide based on the values in Cells C6, C12, and C14. I wrote the code for it and had it working, but for some reason after coming back to it a few days later it no longer works. The code is as follows: Private Sub WorkSheet_Change(ByVal target As Range)...

I had this embedded code in a worksheet to auto re-size columns. When I upgraded to win10/excel2016 it no longer works. Please help! Option Explicit Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.ScreenUpdating = False...