
Creating a VBA macro for speedier comparison work
Mar 12, 2024 · Thanks for the speedy reply! I've attached two documents here, the first is the template that is being completed by x amount of people and then returned to us. The second document is the …
Locked VBA Code Disappears - Microsoft Community
Apr 21, 2023 · Hi Stuart, Thanks for posting in the community. We are happy to help you. According to your description, to narrow down the situation, I would like to suggest you open this workbook in the …
Updated data in for forms - Microsoft Community
Mar 31, 2021 · Hi Paul, Thank you for your reply and further clarification. If you tend to update your data from linked Excel workbook to your forms in Microsoft Forms. It is not feasible to achieve it. Because …
Copy/Move a sheet & break links - Microsoft Community
Jan 14, 2011 · I want a macro to make a copy of the selected sheet (s) to a new workbook and break links with the other sheets or UDFs in the original workbook turning the UDFs/formulas referring to …
I can't save, save as, email or rename my excel workbooks. How do I ...
Feb 7, 2022 · I need to fill in data on a particular workbook that was emailed to me. I can fill in the data, but my program won't let me save it, rename it, save as, or email it out.
Excel2016 VBA workbook.open filenameの構文について
こんにちは。Excel VBAに下記記載があるとします。 workbook.open filename"Aファイル"sheets("Bリスト").selectこの場合ファイル名=Aファイルを開いた後Bリストを参照となるのですが、Excel …
How to Print (not Save as) Excel worksheets as separate PDFs?
Jul 2, 2018 · I have an Excel workbook, with many worksheets, each with a descriptive label. I want to print them as separate PDf files I already have a VBA macro that allow to Save each one as a …
Laufzeitfehler 1004 in Makro - Microsoft Community
Guten Tag, ich habe ein Problem, wenn ich in einem Makro eine neue Excel-Instanz öffne. Die Range-Methode schlägt fehl, wenn mehrere Zellbereiche angegeben werden: Sub worksFine() Dim xls As
VBA macro running in Excel 2016 on Mac OS X 10.13
Jun 18, 2018 · Dear all, I have been using a macro running in Excel to extract individual worksheets from an .xls file and write these to individual .xls files in a folder (macro below). The macro creates the folder
How do I copy conditional formatting from one worksheet to another …
Jun 4, 2013 · How do I copy conditional formatting from one worksheet to another in the same workbook? I am using Office 2010 and created a spreadsheet that I use to track monthly bills to …