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.

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 allocation. So to …

Jun 23, 2025 · How do undo an action only in my current spreadsheet? Undo from single workbook only, with multiple workbooks open Undo when several files are open in Excel 2010 This also means that, …

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 doesn't …

Feb 25, 2013 · I have to have 3 or 4 workbooks open at the same time with the same (named) macros in them. To make them work I use the WorkbookActivate event to assign keys to macros. e.g.: …

Feb 17, 2018 · BR BrandyTurner1 Created on February 17, 2018 Last Modified date per sheet in NON macro enabled shared workbook

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 2003 I …

Mar 30, 2016 · I have an Excel workbook (Workbook 1) that contains pivot tables that use data from a different workbook (Workbook 2). Both workbooks are shared with colleagues on Dropbox.

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 your OneDrive …

May 8, 2021 · I am new to implementing Data Bars. I want to apply Data Bar Conditional Formatting to a range of data on one sheet in a workbook. The data will either be a 0,1, or 2. I understand the bars …