Date Picker not displaying in correct cell when worksheet opened

JessLC

New Member
Joined
Oct 19, 2014
Messages
2
Hi Everyone, Hoping I can get some help with this problem (be kind please I'm a first time poster :) )
I have just discovered the date time picker and have inserted it into a spreadsheet. The spreadsheet is saved as a macro enabled template however when I open either the template itself or a new version the date time picker drop down box is not where I saved it (in cell D8), rather it appears it the top left corner over the column titles of A B C. If I scroll a little it goes back to the correct cell (D8), however I'm giving this to other people to fill out and don't want to have to tell them to scroll before entering data.

I'd insert a screenshot but I'm a bit of a nube and don't know how to get the location of the pic to a URL address to insert it.

Thanks for any idea/help
Jess
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,940
Office Version
2019, 2016, 2013
Platform
Windows
sounds like at some stage you are selecting A1 and when its pasted it goes to the selected cell

you can post your code between [code ] [/code] tages
 

JessLC

New Member
Joined
Oct 19, 2014
Messages
2
Thanks, that was the first thing I thought of too. The drop down actually appears above the A1 cell, where you would normally select the column A or B so I didn't think that would be it but I tried it again making sure A1 was not selected and the same thing happens.
 

Forum statistics

Threads
1,085,495
Messages
5,384,007
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top