Excel Calendar "Microsoft Month View" creating a second, unwanted calendar

chris pike
chris pike used Ask the Experts™
on
Excel calendar from "MicrosoftMonthView" creating double calendar.
I HAVE ALSO TRIED MICROSOFT DATE AND TIME PICKER, IT DOES THE SAME THING, CREATES A DOUBLE.
I want only one single calendar, not two.
If you maximize then restore the second calendar window disappears, but I don't want to have the use do that everytime when they open.
Book1.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Is this acceptable? Click H3.
29161333.xlsm
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Or you can use the attached workbook where i've added this code in Worbook_Open in your workbook.
Private Sub Workbook_Open()
Application.ScreenUpdating = False

ActiveWindow.WindowState = xlMaximized
ActiveWindow.WindowState = xlNormal

Application.ScreenUpdating = True
End Sub

Open in new window

29161333a.xlsm

Author

Commented:
Hey Martin,
Nice to see you again. Thanks so much for your Help !!!!
Thanks for the 2 suggestions. I will use the second one as it is much easier for me to drop into my actual workbook.

You are THE MAN !!!!!

Chris

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial