About 1,977,749 results (5,914 milliseconds)
Scripting button using openpyxl
https://groups.google.com/g/openpyxl-users/c/Hf8V_5G5FZA I am using openpyxl to script pivot tables. Because pivot tables are not directly supported, I created a macro that creates a pivot table, and that macro is ...
Add randomize button to sheet - Google Docs Editors Community
https://support.google.com/docs/thread/271645744/add-randomize-button-to-sheet?hl=en Apr 27, 2024 ... Is there any way to do this is Sheets or is this button exclusive to Excel? For reference I also cant get it on Numbers on my mac or Airtable or ...
Run Macro follwing click on CommandButton Userform - Please Help!
https://groups.google.com/g/microsoft.public.mac.office.excel/c/zP5m5TREnGw Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC Hello Everyone, I'm working on Excel 2004. I've created a UserForm in VBA with one ...
How can I create a shortcut for "paste special" + transpose?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/mC7mdiZOhPM I recently discovered how to record a macro in my previous version of office ... Can it be included in future Mac Excel releases??? Please??????? Is there ...
How do I create an "uncheck all" button or box for my list of items ...
https://support.google.com/docs/thread/94374837/how-do-i-create-an-uncheck-all-button-or-box-for-my-list-of-items?hl=en Jan 20, 2021 ... Side question: In the 'Output' I have a list of items generated from the checked columns. Can I edit the formula to include a bullet point next ...
SUM across sheets not working in google sheets, but works in ...
https://support.google.com/docs/thread/79635943/sum-across-sheets-not-working-in-google-sheets-but-works-in-windows-excel?hl=en Oct 29, 2020 ... If I run this function in excel on mac, it adds up the cell on each ... Or maybe even creating a macro might do the trick? Thank you ...
Create counter button that adds a value to a cell by clicking on it ...
https://support.google.com/docs/thread/82122258/create-counter-button-that-adds-a-value-to-a-cell-by-clicking-on-it?hl=en Nov 10, 2020 ... If this is not possible, then a checkbox would do, but I figured there might be just like a button that can be pressed. A macro image with a ...
Since Latest Mac OS, can no longer upload any files in Chrome ...
https://support.google.com/chrome/thread/134852610/since-latest-mac-os-can-no-longer-upload-any-files-in-chrome?hl=en Nov 10, 2021 ... ... add it. > Now restart Chrome. Worked for me thanks to Scott ... After restarting browser upload button starts working. Last edited ...
Google Sheets Macros | Apps Script | Google for Developers
https://developers.google.com/apps-script/guides/sheets/macros Aug 29, 2024 ... Once you've recorded a macro, you can link it to a keyboard shortcut in the form Ctrl+Alt+Shift+Number . You can use that shortcut to quickly ...
Adding a button that generates a timestamp in the next row anytime ...
https://support.google.com/docs/thread/186115214/adding-a-button-that-generates-a-timestamp-in-the-next-row-anytime-it-s-clicked?hl=en Oct 28, 2022 ... Welcome to the Google Docs Editors help community. You are right that creating buttons, and attaching the script to them would be very tedious ...
In google sheets can I set it so that all cells word wrap and align at ...
https://support.google.com/docs/thread/4372413/in-google-sheets-can-i-set-it-so-that-all-cells-word-wrap-and-align-at-top-by-default?hl=en Apr 17, 2019 ... ... spreadsheet run the macro. You can ... macro to a button which is what I like to do. Like this: Insert-Drawing [then make a round button ...
script editor does not show in google sheets/tools - Google Docs ...
https://support.google.com/docs/thread/93524392/script-editor-does-not-show-in-google-sheets-tools?hl=en Jan 14, 2021 ... You can simply create a new file (the plus sign next to Files) and ... Yes the spreadsheet now shows red cells but I didn't run the macro.
Is it possible to set the "Tab Index" of specific cells in Google Sheets ...
https://support.google.com/docs/thread/10619354/is-it-possible-to-set-the-tab-index-of-specific-cells-in-google-sheets?hl=en Jul 25, 2019 ... To see the script go to Tools > Script editor. It has 2 buttons on the Form sheet where one is to send the data to the Data sheet and one to ...
Create a data entry form within google sheets that can also populate ...
https://support.google.com/docs/thread/18670422/create-a-data-entry-form-within-google-sheets-that-can-also-populate-with-existing-data?hl=en Nov 5, 2019 ... Sheets,Mac OS,Business. Locked. This question is locked ... ....after clicking the link press the "Make a copy" button to have your own copy.
Saved .xslm file must be repaired to open; file loaded with keep_vba ...
https://groups.google.com/g/openpyxl-users/c/eqArCVHoqsg Aug 15, 2018 ... I am writing to an .xlsm Excel file containing VBA controls on numerous sheets including radio buttons. When I load the file with openpyxl in my script, I am ...
Creating a macro to fill out a log from a form - Google Docs Editors ...
https://support.google.com/docs/thread/78539644/creating-a-macro-to-fill-out-a-log-from-a-form?hl=en Oct 22, 2020 ... We have several forms and logs all similar on a document so just trying to get them to work better with "a click of a button" I had an excel ...
When I record a macro in google sheets it requires authorization to ...
https://support.google.com/docs/thread/143650903/when-i-record-a-macro-in-google-sheets-it-requires-authorization-to-run-on-the-same-sheet?hl=en Jan 2, 2022 ... 1. After seeing the first pop-up of Authorization Required and selecting the Continue button, you have to select your relevant account.
Upload a file to google sheets cell - Google Docs Editors Community
https://support.google.com/docs/thread/15779267/upload-a-file-to-google-sheets-cell?hl=en Oct 1, 2019 ... I think Google could do this and create a killer Airtable competitor and a much more feature-rich spreadsheet program over Excel.
Excel-DNA add ins using ExcelCommand present in excel but ...
https://groups.google.com/g/exceldna/c/c8CkXuIIVts Jun 2, 2023 ... ... button that would read the excel sheet for the necessary information. ... Does the macro run correctly when you press this button? I think it ...
Easiest way to insert multiple copied rows?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/zNf0gGlLZk8 Apr 24, 2010 ... The 'Insert Options' & 'Paste Options' buttons can be disabled in Excel> ... list then sort the list. HTH |:>) Bob Jones [MVP] Office:Mac.