Excel - Save your macro Tutorial
In this video, you will learn how to save, share, and organize content using OneNote.
The video covers the process of saving web pages to OneNote using the OneNote Web Clipper extension in Microsoft Edge or Google Chrome.
You can choose to save a specific region, article, or the entire page.
Once saved, you can view and add notes to your clips in OneNote.
This tutorial will help you efficiently save and organize your online content using OneNote.
- 2:59
- 4017 views
-
Excel - One click Forecasting
- 1:01
- Viewed 4349 times
-
Excel - 3D Maps
- 1:41
- Viewed 6993 times
-
Excel - More complex formulas
- 4:17
- Viewed 5350 times
-
Excel - VLOOKUP: How and when to use it
- 2:38
- Viewed 4987 times
-
Excel - Advanced formulas and references
- 4:06
- Viewed 5038 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 5069 times
-
Excel - Automatic Data Entry in Excel
- 0:41
- Viewed 629 times
-
Excel - TEXTJOIN
- 0:47
- Viewed 5019 times
-
Remove a watermark
- 2:20
- Viewed 43339 times
-
Change the default font for your emails
- 1:09
- Viewed 29092 times
-
Collapsible headings
- 3:03
- Viewed 22858 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 21894 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 20633 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 19290 times
-
Create automatic reminders
- 4:10
- Viewed 13702 times
-
Protect a document shared by password
- 1:41
- Viewed 12475 times
-
Add a sound effect to a transition
- 3:45
- Viewed 12004 times
-
Morph transition
- 0:43
- Viewed 11760 times
-
Remove a watermark
- 2:20
- Viewed 43339 times
-
Change the default font for your emails
- 1:09
- Viewed 29092 times
-
Collapsible headings
- 3:03
- Viewed 22858 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 21894 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 20633 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 19290 times
-
Create automatic reminders
- 4:10
- Viewed 13702 times
-
Protect a document shared by password
- 1:41
- Viewed 12475 times
-
Add a sound effect to a transition
- 3:45
- Viewed 12004 times
-
Morph transition
- 0:43
- Viewed 11760 times
-
Use Facilitator notes after a meeting
- 02:53
- Viewed 13 times
-
Enable Facilitator during a Teams meeting
- 02:04
- Viewed 20 times
-
Enable Facilitator before a Teams meeting
- 02:16
- Viewed 17 times
-
Prerequisites and limitations of Facilitator
- 01:55
- Viewed 16 times
-
Required licenses for using Facilitator in Teams
- 02:09
- Viewed 31 times
-
Understand Facilitator in Teams
- 02:14
- Viewed 13 times
-
Configure a child agent
- 03:52
- Viewed 55 times
-
Enhance the assistant with tools
- 02:42
- Viewed 22 times
-
Can you request the deletion of your data ?
- 01:40
- Viewed 74 times
-
GPDR : 4 simple reflexes
- 05:07
- Viewed 83 times
Objectifs :
This video aims to guide users on how to save a macro in the Personal Macro Workbook in Excel, ensuring that the macro is always available for use across different workbooks. It covers the steps to record a macro, copy existing macro code, and manage the visibility of the Personal Macro Workbook.
Chapitres :
-
Introduction to Personal Macro Workbook
The Personal Macro Workbook is a hidden workbook in Excel that loads automatically every time you start the application. This allows users to store macros that can be accessed from any workbook, enhancing productivity and efficiency. -
Recording a Macro
To save a macro in the Personal Macro Workbook, start by launching the macro recorder. Assign the macro the same name as the original, 'FillDaysRelativeR', and select 'Personal Macro Workbook' under the 'Store macro in' option. After clicking OK, stop the recording immediately, as the steps will be copied from an existing macro. -
Accessing and Editing Macros
Open the Macros dialog box to view the recorded macros. Locate the newly recorded macro in the Personal Macro Workbook. To edit it, click 'Edit' to open the Visual Basic Editor. Here, you will see the macro code starting with 'Sub FilldaysrelativeR'. Select all the code, including 'End Sub', and copy it. -
Unhiding the Personal Macro Workbook
If you encounter a message stating that the workbook is hidden and cannot be edited, you need to unhide it. Click on the 'View' tab and select 'Unhide'. Choose the hidden workbook and click OK. Now, navigate to the 'Developer' tab, click 'Macros', and select the macro in the Personal Workbook to edit. -
Pasting and Saving Changes
In the Visual Basic Editor, replace the limited instructions of the recorded macro with the copied code. After pasting, close the editor to save the changes. To clean up, hide the Personal Workbook by switching to it and clicking 'Hide' under the 'View' tab. -
Ensuring Macro Availability
Once the Personal Macro Workbook is set up, the macro will be available whenever you open Excel, whether you are working on an existing workbook or creating a new one. Remember to save the Personal Workbook before closing Excel to ensure that your macro is retained. -
Conclusion and Next Steps
In the next video, viewers will learn how to assign a button to a macro, further enhancing the usability of macros in Excel. This concludes the current tutorial on saving and managing macros in the Personal Macro Workbook.
FAQ :
What is a Personal Macro Workbook?
A Personal Macro Workbook is a hidden workbook in Excel that automatically opens every time you start Excel. It allows you to store macros that you want to use across different workbooks.
How do I save a macro to my Personal Macro Workbook?
To save a macro to your Personal Macro Workbook, start the macro recorder, choose 'Personal Macro Workbook' under 'Store macro in', and then record your macro. After recording, you can edit the macro in the Visual Basic Editor.
What is the Visual Basic Editor used for?
The Visual Basic Editor is used to write, edit, and manage macros in Excel. It allows users to modify the code of their macros for more advanced functionality.
How can I unhide my Personal Macro Workbook?
To unhide your Personal Macro Workbook, go to the 'View' tab in Excel and click on 'Unhide'. Select the Personal Macro Workbook from the list and click OK.
Can I use macros from my Personal Macro Workbook in any Excel file?
Yes, macros stored in your Personal Macro Workbook are available in any Excel file you open on the same computer where the workbook is saved.
Quelques cas d'usages :
Automating Data Entry
A financial analyst can use a macro stored in the Personal Macro Workbook to automate the process of entering monthly sales data into a report. This saves time and reduces the risk of errors.
Generating Reports
A project manager can create a macro that formats and generates weekly project status reports. By saving this macro in the Personal Macro Workbook, it can be reused for different projects without needing to recreate the formatting each time.
Batch Processing Data
A data scientist can develop a macro to clean and process large datasets. By storing this macro in the Personal Macro Workbook, it can be applied to any dataset opened in Excel, improving efficiency.
Customizing Excel Functions
An accountant can create a macro that customizes Excel functions for specific calculations. By saving it in the Personal Macro Workbook, the accountant can easily access and apply it across various financial models.
Glossaire :
Macro
A macro is a set of instructions that automate tasks in Excel. It allows users to perform repetitive actions quickly.
Personal Macro Workbook
A special hidden workbook in Excel that opens automatically every time Excel starts. It is used to store macros that you want to be available in any workbook.
Visual Basic Editor
A tool within Excel that allows users to write and edit macros using Visual Basic for Applications (VBA).
Sub
Short for 'Subroutine', it is a block of code in VBA that performs a specific task. Each macro begins with 'Sub' followed by the macro name.
End Sub
A statement in VBA that indicates the end of a subroutine. It is necessary to define where the macro code finishes.
Unhide
The action of making a hidden workbook visible again in Excel.
Hide
The action of making a workbook invisible in Excel without closing it.