Time & date picker.

**Gareth_iowc** · 10-09-2012, 08:54 AM

Hello,

i having some trouble with a spreadsheet i have made and was wondering if some on could help. I have been stuck with it for the past week and not getting any where

The Problem:

I am having trouble with the microsoft date & time picker.
Once you open the spreadsheet and click enable editing, enable content you will see the broken time and date pickers under D & G. But if you scroll down until they are out of view and then back up they will reappear working.

any suggestions?

I will attach the sheet to this post.

many thanks

**greggy99** · 10-09-2012, 09:01 AM

maybe there is something on your excel...just uninstall the office and install it again...^_^

i download your workbook and its totally fine...

hope its help...

**Gareth_iowc** · 10-09-2012, 09:13 AM

thanks for taking the time to look

hmm strange. not somthing we can do as its a company system and its the same setup over 400+ computers. Tried this doc on 5 different computers and it's all the same.

**Gareth_iowc** · 10-09-2012, 09:45 AM

This is how it looks on our computers office 2010
upload.jpg

**Gareth_iowc** · 10-10-2012, 10:45 AM

For any one with the same problem i managed to fix it with this code -

Please Login or Register  to view this content.

The code clicks on cell b2 then scrolls down 13 cell then back up 13.

For some reason scrolling down fixes the broken calendar object.

Time & date picker.

LinkBack

Thread Tools

Rate This Thread

Display

Time & date picker.

Re: Time & date picker.

Re: Time & date picker.

Re: Time & date picker.

Re: Time & date picker.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions