With every Microsoft Office 365 for enterprise, business, education, and government subscription, Microsoft Support provides global technical, pre-sales, billing and, subscription support. Support is available both online through the Microsoft365 admin center and by telephone for both paid and trial subscriptions. For more information, see Microsoft Support Options. With Office 2010 support now reaching the final year of its 10-year lifecycle, Microsoft is ramping up its messaging for customers to migrate to its newer Office 365 ProPlus bundle. If you have any questions regarding support for a product, please contact your Microsoft Account Representative. If you need technical support, visit the Microsoft Support website. Products governed by the Modern Policy. The following products, governed by the Modern Policy, will retire in 2020. If you've always wanted to be better at Excel, an Excel notes template will help you get there. Take this Excel tour and, in 10 easy steps, you'll have the skills you need to make the most of the application. Your welcome to Excel tutorial starts with simple functions, like adding numbers and automatically filling cells, then gradually introduces you to more involved operations. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To create the calendar, follow these steps. Microsoft Excel 2003. Create a new workbook.
-->Note
Free european roulette. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Summary
This article contains a sample Microsoft Visual Basic for Applications macro (Sub procedure) that prompts you for the month and year and creates a monthly calendar using a worksheet.
Resolution
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
To create the calendar, follow these steps.
Microsoft Excel 2003
- Create a new workbook.
- On the Tools menu, point to Macro, and then click Visual Basic Editor.
- On the Insert menu, click Module.
- Copy the Visual Basic for Applications code below into the module sheet.
- On the File menu, click 'Close and Return to Microsoft Excel.'
- Click the Sheet1 tab.
- On the Tools menu, point to Macro, and then click Macros.
- Click CalendarMaker, and then click Run to create the calendar.
Microsoft Excel 2007 or later
- Create a new workbook.
- On the Developer ribbon, Click Visual Basic.
- On the Insert menu, click Module.
- Copy the Visual Basic for Applications code below into the module sheet.
- On the File menu, click 'Close and Return to Microsoft Excel.'
- Click the Sheet1 tab.
- On the Developer ribbon, click Macros
- Click CalendarMaker, and then click Run to create the calendar.
Note
If the Developer Ribbon is not showing go to Excel Options and enable it. In Excel 2007 you will find it in the Popular menu and in Excel 2010 you will find it in the Customize Ribbon menu.
Sample Visual Basic Procedure
You can add other code to customize the calendar to meet your needs. Insert extra rows for entry on the screen for each day or resize the screen to see all of the calendar based on screen size and resolution.
Microsoft Excel Support Forum
Originally published: October 29, 2018
Updated: July 17, 2020
Please go here to search for your product's lifecycle.
The following list represents products retiring or reaching the end of support in 2020. Upon retirement or end of support, there will be no new security updates, non-security updates, free or paid assisted support options or online technical content updates. Go here to learn about Fixed and Modern Lifecycle policies and service packs. Adobe acrobat update.
For a comprehensive list of Microsoft products and their lifecycle policy timelines, including migration options, please search the Microsoft Lifecycle Product Database.
If you have any questions regarding support for a product, please contact your Microsoft Account Representative. Rocketek bluetooth adapter driver for mac. If you need technical support, visit the Microsoft Support website.
Products governed by the Modern Policy
Microsoft Excel Support Page
The following products, governed by the Modern Policy, will retire in 2020.
Products (Modern Policy) | Retirement |
---|---|
System Center, version 1807 (all editions) | January 24, 2020 |
Azure Container Service Windows Analytics | January 31, 2020 |
Visio Services in SharePoint Online | September 30, 2020 |
Windows 10, version 1709 (Enterprise, Education, IoT Enterprise) | October 13, 2020 |
Windows 10, version 1803 (Enterprise, Education, IoT Enterprise) Windows 10, version 1809 (Home, Pro, Pro Education, Pro for Workstation, IoT Core) Windows Server version 1809 (Datacenter Core, Standard Core) | November 10, 2020 |
Configuration Manager (current branch), version 1810 | December 1, 2020 |
Windows 10, version 1903 (Enterprise, Home, Pro, Pro Education, Pro for Workstations, IoT Enterprise) Windows Server, version 1903 (Datacenter, Standard) | December 8, 2020 |
InMage/ASR Scout | December 31, 2020 |
Products governed by the Fixed Policy
The following products, governed by the Fixed Policy, will end support in 2020.
Product (Fixed Policy) | End of Support |
---|---|
Dynamics NAV 2009 R2 Expression Blend 3 Expression Design 3 Expression Encoder 3 Expression Studio 3 Expression Web 3 Hyper-V Server 2008 Hyper-V Server 2008 R2 Windows 7 Windows Embedded Handheld 6.5 Windows Server 2008 R2 Windows Server 2008 Windows Server Update Services 3.0 Windows Storage Server 2008 (all editions) | January 14, 2020 |
Internet Explorer 10 | January 31, 2020 |
Forefront Unified Access Gateway 2010 Forefront Threat Management Gateway 2010 (all editions) Microsoft HPC Pack 2008 (all editions) Windows Identity Foundation | April 14, 2020 |
Wunderlist | May 6, 2020 |
Expression Encoder 4 Expression Studio 4 Expression Web 4 Expression Studio Ultimate 4 Microsoft Application Virtualization 4.6 for Terminal Services Microsoft Application Virtualization 4.6 for Windows Desktops Microsoft Application Virtualization 4.6 for Remote Desktop Services Microsoft Application Virtualization 4.6 Sequencer Microsoft Application Virtualization Hosting 4.6 for Windows Desktops Visual Studio Team Foundation Server 2010 Visual Studio 2010 (all editions) Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express Windows MultiPoint Server 2010 (all editions) | July 14, 2020 |
Internet Information Services Smooth Streaming Client 1.0 Microsoft Report Viewer Redistributable 2010 System Center Service Manager 2010 Windows Communication Foundation RIA Services | September 8, 2020 |
Access 2010 Dynamics GP 2010 Excel 2010 Excel Mobile 2010 Exchange Server 2010 (all editions) FAST Search Server 2010 (all editions) Groove Server 2010 Office 2010 (all editions) OneNote 2010 PowerPoint 2010 Project 2010 Publisher 2010 Search Server 2010 System Center Data Protection Manager 2010 System Center Essentials 2010 Visio 2010 (all editions) Word 2010 Windows Embedded Standard 7 Office 2016 for Mac (all editions) Excel 2016 for Mac Outlook 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac | October 13, 2020 |
Service Packs
The following service packs apply to Fixed Policy products, and will end support in 2020.
Service Pack | End of Support |
---|---|
Dynamics 365 Business Central on-premises | April 14, 2020 |
Microsoft Identity Manager 2016 Service Pack 1 | November 4, 2020 |
Products moving to Extended Support
The following products will be moving from Mainstream to Extended Support in 2020. Extended Support includes security updates at no cost, and paid non-security updates and support. Additionally, Microsoft will not accept requests for design changes or new features during the Extended Support phase. Movist pro 2 1 3.
Product | End of Mainstream Support |
---|---|
Dynamics C5 2015 Dynamics CRM 2015 Dynamics SL 2015 Dynamics NAV 2015 | January 14, 2020 |
Cloud Platform System Cloud Platform System Standard Dynamics GP 2015 Dynamics GP 2015 R2 Microsoft User Experience Virtualization 2.1 Service Pack 1 | April 14, 2020 |
Azure StorSimple 8000 Series Microsoft Azure StorSimple 1200 Series StorSimple Data Manager | July 1, 2020 |
Access 2016 Excel 2016 Exchange Server 2016 (Enterprise, Standard) Office Home and Business 2016 Office Home and Student 2016 Office Professional 2016 Office Professional Plus 2016 Office Standard 2016 Project Professional 2016 Project Standard 2016 Microsoft Publisher 2016 Outlook 2016 PowerPoint 2016 Skype for Business 2016 Skype for Business Server 2015 Visio Professional 2016 Visio Standard 2016 Visual Studio 2015 (all editions) Visual Studio Team Foundation Server 2015 (all editions) Windows 10 Enterprise 2015 LTSB Windows 10 IoT Enterprise 2015 LTSB Windows Defender Exploit Guard Word 2016 | October 13, 2020 |
Change Log
Microsoft Excel Support Forum
Originally published: October 29, 2018
Updated: July 17, 2020
Please go here to search for your product's lifecycle.
The following list represents products retiring or reaching the end of support in 2020. Upon retirement or end of support, there will be no new security updates, non-security updates, free or paid assisted support options or online technical content updates. Go here to learn about Fixed and Modern Lifecycle policies and service packs. Adobe acrobat update.
For a comprehensive list of Microsoft products and their lifecycle policy timelines, including migration options, please search the Microsoft Lifecycle Product Database.
If you have any questions regarding support for a product, please contact your Microsoft Account Representative. Rocketek bluetooth adapter driver for mac. If you need technical support, visit the Microsoft Support website.
Products governed by the Modern Policy
Microsoft Excel Support Page
The following products, governed by the Modern Policy, will retire in 2020.
Products (Modern Policy) | Retirement |
---|---|
System Center, version 1807 (all editions) | January 24, 2020 |
Azure Container Service Windows Analytics | January 31, 2020 |
Visio Services in SharePoint Online | September 30, 2020 |
Windows 10, version 1709 (Enterprise, Education, IoT Enterprise) | October 13, 2020 |
Windows 10, version 1803 (Enterprise, Education, IoT Enterprise) Windows 10, version 1809 (Home, Pro, Pro Education, Pro for Workstation, IoT Core) Windows Server version 1809 (Datacenter Core, Standard Core) | November 10, 2020 |
Configuration Manager (current branch), version 1810 | December 1, 2020 |
Windows 10, version 1903 (Enterprise, Home, Pro, Pro Education, Pro for Workstations, IoT Enterprise) Windows Server, version 1903 (Datacenter, Standard) | December 8, 2020 |
InMage/ASR Scout | December 31, 2020 |
Products governed by the Fixed Policy
The following products, governed by the Fixed Policy, will end support in 2020.
Product (Fixed Policy) | End of Support |
---|---|
Dynamics NAV 2009 R2 Expression Blend 3 Expression Design 3 Expression Encoder 3 Expression Studio 3 Expression Web 3 Hyper-V Server 2008 Hyper-V Server 2008 R2 Windows 7 Windows Embedded Handheld 6.5 Windows Server 2008 R2 Windows Server 2008 Windows Server Update Services 3.0 Windows Storage Server 2008 (all editions) | January 14, 2020 |
Internet Explorer 10 | January 31, 2020 |
Forefront Unified Access Gateway 2010 Forefront Threat Management Gateway 2010 (all editions) Microsoft HPC Pack 2008 (all editions) Windows Identity Foundation | April 14, 2020 |
Wunderlist | May 6, 2020 |
Expression Encoder 4 Expression Studio 4 Expression Web 4 Expression Studio Ultimate 4 Microsoft Application Virtualization 4.6 for Terminal Services Microsoft Application Virtualization 4.6 for Windows Desktops Microsoft Application Virtualization 4.6 for Remote Desktop Services Microsoft Application Virtualization 4.6 Sequencer Microsoft Application Virtualization Hosting 4.6 for Windows Desktops Visual Studio Team Foundation Server 2010 Visual Studio 2010 (all editions) Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express Windows MultiPoint Server 2010 (all editions) | July 14, 2020 |
Internet Information Services Smooth Streaming Client 1.0 Microsoft Report Viewer Redistributable 2010 System Center Service Manager 2010 Windows Communication Foundation RIA Services | September 8, 2020 |
Access 2010 Dynamics GP 2010 Excel 2010 Excel Mobile 2010 Exchange Server 2010 (all editions) FAST Search Server 2010 (all editions) Groove Server 2010 Office 2010 (all editions) OneNote 2010 PowerPoint 2010 Project 2010 Publisher 2010 Search Server 2010 System Center Data Protection Manager 2010 System Center Essentials 2010 Visio 2010 (all editions) Word 2010 Windows Embedded Standard 7 Office 2016 for Mac (all editions) Excel 2016 for Mac Outlook 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac | October 13, 2020 |
Service Packs
The following service packs apply to Fixed Policy products, and will end support in 2020.
Service Pack | End of Support |
---|---|
Dynamics 365 Business Central on-premises | April 14, 2020 |
Microsoft Identity Manager 2016 Service Pack 1 | November 4, 2020 |
Products moving to Extended Support
The following products will be moving from Mainstream to Extended Support in 2020. Extended Support includes security updates at no cost, and paid non-security updates and support. Additionally, Microsoft will not accept requests for design changes or new features during the Extended Support phase. Movist pro 2 1 3.
Product | End of Mainstream Support |
---|---|
Dynamics C5 2015 Dynamics CRM 2015 Dynamics SL 2015 Dynamics NAV 2015 | January 14, 2020 |
Cloud Platform System Cloud Platform System Standard Dynamics GP 2015 Dynamics GP 2015 R2 Microsoft User Experience Virtualization 2.1 Service Pack 1 | April 14, 2020 |
Azure StorSimple 8000 Series Microsoft Azure StorSimple 1200 Series StorSimple Data Manager | July 1, 2020 |
Access 2016 Excel 2016 Exchange Server 2016 (Enterprise, Standard) Office Home and Business 2016 Office Home and Student 2016 Office Professional 2016 Office Professional Plus 2016 Office Standard 2016 Project Professional 2016 Project Standard 2016 Microsoft Publisher 2016 Outlook 2016 PowerPoint 2016 Skype for Business 2016 Skype for Business Server 2015 Visio Professional 2016 Visio Standard 2016 Visual Studio 2015 (all editions) Visual Studio Team Foundation Server 2015 (all editions) Windows 10 Enterprise 2015 LTSB Windows 10 IoT Enterprise 2015 LTSB Windows Defender Exploit Guard Word 2016 | October 13, 2020 |
Change Log
September 2019 editsADDED: Windows Analytics, Windows Storage Server 2008 (all editions), Internet Explorer 10, StorSimple Data Manager, Visio Services in SharePoint Online
ADDED: Windows 10, version 1903 (Enterprise, Home, Pro, Pro for Workstations, IoT Enterprise) and Windows Server, version 1903 (Datacenter, Standard, IoT Enterprise)
EDITED: Exchange Server 2010 (all editions) support extended from January 14, 2020 to October 13, 2020
January 2020 edits
ADDED: Exchange Server 2010, Microsoft Application Virtualization 4.6 for Remote Desktop Services, Expression Studio 4, Windows 10 Pro Education,
EDITED: Visual Basic 2010 Express, Visual Basic C# 2010 Express, Visual Basic C++ 2010 Express, Visual Web Developer 2010 Express, Expression Encoder 4, Expression Web 4 date updated to July 14, 2020
EDITED: OneNote 2016 Mainstream Support extended from October 13, 2020 to October 10, 2023
EDITED: specific editions removed, 'all editions' added to parent listing
February 2020 edits
ADDED: Dynamics 365 Business Central on-premises, Microsoft Identity Manager 2016 Service Pack 1
April 2020 edits
EDITED: Windows 10, version 1709 (Enterprise, Education, IoT Enterprise) extended to October 13, 2020
EDITED: Windows 10, version 1809 (Home, Pro, Pro Education, Pro for Workstation, IoT Core), Windows Server version 1809 (Datacenter Core, Standard Core) extended to November 10, 2020
REMOVED: PerformancePoint Services in SharePoint Server 2010, Project Server 2010, SharePoint Server 2010 (support extended from October 13, 2020 to April 13, 2021)
June 2020 edits
REMOVED: Windows Defender Antivirus for Windows 10
July 2020 edits
ADDED: Expression Studio Ultimate 4
EDITED: Visual Basic 2010 Express, Visual C# 2010 Express, and Visual C++ 2010 Express corrections