
How can I paste the date and time from another workbook and …
Aug 22, 2024 · How can I paste the date and time from another workbook and prevent excel from changing the date to 1/0/1900? This is the data I'm copying from a spreadsheet I received.
Automatically update a cell in a workbook based on the value of a …
Apr 2, 2015 · And so on. I'm trying to do this for a workbook with multiple worksheets of monthly values for mutual funds I own and another workbook (single worksheet) that shows asset …
Excel freezes, Hit enter, it goes to another workbook.
Nov 17, 2020 · Working on multiple opened workbooks. All of a sudden, the workbook I am working on seems to freeze up. I hit enter, I am taken to another workbook and all is unfrozen. …
Python via Excel Beta Insiders Still Not Working
Nov 2, 2023 · For a long time, Python didn't work.When my Windows was recently updated, on first attempt, Python worked ... But only once!Now when I go to execute any Python code, it …
subscript out of range error 9 change name of worksheet
Jan 28, 2015 · You can try the following. If the workbook is open then Save and close it. Close Excel. Backup your workbook as follows. Create a new folder in windows explorer While still in …
Last Modified date per sheet in NON macro enabled shared …
Feb 17, 2018 · BR BrandyTurner1 Created on February 17, 2018 Last Modified date per sheet in NON macro enabled shared workbook
Deactivate/Activate (Worksheet Menu Bar) - Microsoft Community
Apr 13, 2012 · With Application .DisplayFullScreen = False .CommandBars ("Worksheet Menu Bar").Enabled = True End With End Sub As my Worksheet is Protected and the users uses …
Filtering Issue - Microsoft Excel Online - Microsoft Community
Sep 4, 2021 · I will send a private message to collect the workbook. You can save the workbook to your computer and then upload it in the private message or create a duplicate workbook in …
vba to hide the worksheet if it is open - Microsoft Community
Nov 22, 2022 · Microsoft Q&A... .. We’re retiring the Xbox forums. It is no longer possible to create questions in the Gaming and Xbox forums, and there is no active monitoring of the …
Hyperlink a cell within workbook - Microsoft Community
Mar 6, 2020 · The free Excel workbook "Professional_Compare" (updated) is available at MediaFire. (compares every cell in two worksheets Or each row in one worksheet against all …