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
- 4335 views
-
Outlook - Create and modify a group
- 2:19
- Viewed 7046 times
-
Excel - Do things quickly with Tell Me
- 1:07
- Viewed 4011 times
-
Excel - New Chart types
- 1:52
- Viewed 5640 times
-
Excel - Automatic Data Entry in Excel
- 0:41
- Viewed 630 times
-
Excel - One click Forecasting
- 1:01
- Viewed 5219 times
-
Excel - 3D Maps
- 1:41
- Viewed 9698 times
-
Excel - Ink Equation
- 0:41
- Viewed 8354 times
-
Excel - Improved version history
- 0:51
- Viewed 5022 times
-
Remove a watermark
- 2:20
- Viewed 67687 times
-
Change the default font for your emails
- 1:09
- Viewed 62812 times
-
Collapsible headings
- 3:03
- Viewed 36632 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30636 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29760 times
-
Add headers and footers to slides
- 3:52
- Viewed 24809 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24595 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 20934 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20325 times
-
Add sound effects to an animation
- 4:29
- Viewed 19212 times
-
Remove a watermark
- 2:20
- Viewed 67687 times
-
Change the default font for your emails
- 1:09
- Viewed 62812 times
-
Collapsible headings
- 3:03
- Viewed 36632 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 30636 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 29760 times
-
Add headers and footers to slides
- 3:52
- Viewed 24809 times
-
Change footnote font, size, and formatting
- 2:48
- Viewed 24595 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 20934 times
-
Add a sound effect to a transition
- 3:45
- Viewed 20325 times
-
Add sound effects to an animation
- 4:29
- Viewed 19212 times
-
Preparing for the EU AI Act: Timeline and Obligations
- 01:54
- Viewed 115 times
-
Using AI in the Workplace: 3 Tips to Minimize Risks
- 03:10
- Viewed 116 times
-
Shadow AI: Identifying Uncontrolled AI Use
- 02:21
- Viewed 111 times
-
EU AI Act Risk Levels: From Minimal to Unacceptable
- 02:37
- Viewed 153 times
-
Understanding the EU AI Act: A Regulation Governing the Use of AI
- 02:24
- Viewed 120 times
-
Analyze the performance of a newsletter or an edition in Outlook
- 01:30
- Viewed 161 times
-
Collaborate on writing an edition in Outlook
- 01:35
- Viewed 142 times
-
Enhance an edition and create a template in a newsletter
- 06:14
- Viewed 133 times
-
Collaborate on a Clipchamp Project
- 01:21
- Viewed 438 times
-
Create a Video with AI in Clipchamp
- 03:26
- Viewed 389 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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise