Automatically copy date from DTpicker and paste into hidden worksheet

Hi All,

I have a userform with a number of controls on it, one of which is a DTpicker.

I'm trying to automate things so that the date selected on the DTpicker is pasted into a particular cell on a hidden worksheet.

After searching through the various Excel vba forums, the only way I can get the date pasted into the cell involves the hidden worksheet
firstly being unhidden and the particular cell then being selected before the paste action occurs.

I really need this to happen with the hidden worksheet staying hidden - does anyone have any suggestions?

Any help appreciated.

Cheers

Your code may be using .select to bring about what you describe. try with .activate [or without the lie at all - sheets("theother").value = ....]