Results 1 to 3 of 3

Thread: How to setup a pop-up calendar in Microsoft Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    2

    How to setup a pop-up calendar in Microsoft Excel

    How to create a pop up calender in Excel. I tried to use ready made templates that can help me to create the same, but it is not working. They are default sheets with formatting. I cannot create any kind of popup effects. There no templates provided on the web which can help to setup a popup calender in excel. Any help appreciated.

  2. #2
    Join Date
    Jul 2011
    Posts
    434

    Re: How to setup a pop-up calendar in Microsoft Excel

    I am not sure about the popup calender but with the help of below steps you can create automatic calendar.
    1) - as standard, only one date is fixed: the first day of the first month. All others are derived!
    The first month can be any month of the year (September, for example)
    - In "birth year" must include the date of birth and let the formula E1
    = DATE (YEAR (DateClef), 1, 1)
    2) holidays are automatically detected if macros are enabled
    (Calculated from 1900 to 2099!) (Whit Monday near ...)
    3) Saturdays and Sundays are detected without enabling macros.
    4) to enlarge the calendar, just copy the last 3 columns and paste them in a row, as many times as desired (limit f'Excel: 255 Column = 7 years or so.
    5) sizes are obtained using the conditional format (menu: Format> Conditional Formatting ...)
    6) two columns are provided for each day but we can remove one of two ...
    7) for printing, automatically registers the full file name (drive-folder-file) at the time of last backup.

  3. #3
    Join Date
    Aug 2011
    Posts
    580

    Re: How to setup a pop-up calendar in Microsoft Excel

    There are two files attached which can give you a template that you are looking for. Try the same out and I think it will help.

Similar Threads

  1. Replies: 6
    Last Post: 09-04-2012, 12:04 PM
  2. Is there a way to setup Bisection method in Microsoft Excel
    By Sreedharna in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 07:56 PM
  3. Replies: 2
    Last Post: 07-02-2012, 07:50 PM
  4. Replies: 2
    Last Post: 21-01-2012, 04:49 PM
  5. Replies: 5
    Last Post: 23-04-2011, 10:19 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,651,275.93793 seconds with 17 queries