约 50 个结果
在新选项卡中打开链接
  1. Creating a VBA macro for speedier comparison work

    2024年3月12日 · 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 …

  2. Locked VBA Code Disappears - Microsoft Community

    2023年4月21日 · 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 …

  3. Copy/Move a sheet & break links - Microsoft Community

    2011年1月14日 · 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 …

  4. Updated data in for forms - Microsoft Community

    2021年3月31日 · 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. …

  5. I can't save, save as, email or rename my excel workbooks. How do I ...

    2022年2月7日 · 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.

  6. Excel2016 VBA workbook.open filenameの構文について

    こんにちは。Excel VBAに下記記載があるとします。 workbook.open filename"Aファイル"sheets("Bリスト").selectこの場合ファイル名=Aファイルを開いた後Bリストを参照となるのですが、Excel …

  7. How to Print (not Save as) Excel worksheets as separate PDFs?

    2018年7月2日 · 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 …

  8. Hyperlink a cell within workbook - Microsoft Community

    2020年3月6日 · 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 rows in a second …

  9. VBA macro running in Excel 2016 on Mac OS X 10.13

    2018年6月18日 · 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 …

  10. How do I copy conditional formatting from one worksheet to another …

    2013年6月4日 · 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 …