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 …

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 …

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 …

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 …

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 …

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 …

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 …