Help Needed!

[Accidential Techie]

1. I created a protected worksheet that has users enter a date in an unprotected cell. Once the user has entered the date, they must Control +c to run a macro which is an autofill for a two week period. The macro actually unproctects the data range, completes the autofill an then protects the range again. Is there any other way to have the auto fill without the user input of Control C.
2. In the same worksheet can I allow user input into a range but protect the formatting..for example - If I drag and drop from a cell with shading to a cell with no shading ..the shading is moved as well

Thanks for any assistance
Accidential Techi

 

[Dave Peterson]

You've got one reply to your other post in .newusers.