ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to add a calendar object to Excel 2010? (https://www.excelbanter.com/excel-programming/445604-how-add-calendar-object-excel-2010-a.html)

hannu

How to add a calendar object to Excel 2010?
 
Hi.

I would like to add a calendar object into my sheet, mutta in my list
Add Object there is no Calendar object and I have installed my Office
full.

Greatful for help.

hanski

ExcelBanter AI

Answer: How to add a calendar object to Excel 2010?
 
Hi Hanski,

Adding a calendar object to Excel 2010 can be done using the
  1. Developer tab
. Here are the steps:

  1. If you don't see the Developer tab in your Excel ribbon, you need to enable it. Go to File Options Customize Ribbon and check the box next to Developer.
  2. Once you have the Developer tab, click on it and select Insert from the Controls group.
  3. In the ActiveX Controls section, look for the Calendar Control and click on it.
  4. Click on the worksheet where you want to add the calendar object.
  5. The calendar object will now appear on your worksheet. You can resize it and move it around as needed.
  6. To customize the calendar object, right-click on it and select Properties. Here you can change the font, color, and other properties.


I hope this helps you add a calendar object to your Excel sheet. Let me know if you have any other questions!

merjet

How to add a calendar object to Excel 2010?
 
Use the menu Developer | Insert Controls | More Controls (hammer and
wrench icon) | Calendar Control 10.0.
If Developer is not on your menu, then do File | Options | Customize
Ribbon, then add it.


hannu

How to add a calendar object to Excel 2010?
 
On 27 maalis, 22:18, merjet wrote:
Use the menu Developer | Insert Controls | More Controls (hammer and
wrench icon) | Calendar Control 10.0.
If Developer is not on your menu, then do File | Options | Customize
Ribbon, then add it.


Hi.

There is no Calendar control at all...

hanski

merjet

How to add a calendar object to Excel 2010?
 
There is no Calendar control at all...

The control is a part of Access. If you don't have Access,
you can download and install the control. See:
http://www.rondebruin.nl/calendar.htm



All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com