Date Picker in Protected Worksheet

[AndyTampa]

I'm trying to create a spreadsheet where people can't mess with the formulas and I'd like to use the Date Picker on it. The problem is that once I protect the worksheet, the Date Picker no longer functions. I've set the Locked feature to FALSE and unprotected the referenced cell, but it still doesn't work. I am on my work network.

What could be blocking the Date Picker from functioning only when it's protected?

 

[James006]

Hi,

Just Unprotect your worksheet at the beginning of your code ...and Protect it again once your updates are done ...

HTH

 

[AndyTampa]

Hi,

Just Unprotect your worksheet at the beginning of your code ...and Protect it again once your updates are done ...

HTH

Code? I'm not using code. I'm using the Microsoft Date and Time Picker Add-in. Unprotecting the worksheet to use it is not feasible. Others will be using this and it should just work. "Select the date" is what I'm looking to tell people and not "Unprotect the worksheet, select the date, protect the worksheet, and try not to screw up any other cells in the process".

 

[Smitty]

What version of Excel & Date/Time Picker are you using?

 

[AndyTampa]

What version of Excel & Date/Time Picker are you using?

I'm at home right now but the computer is at work. I'm pretty sure it is Office 2010 with whatever add-in comes with it.

 

[AndyTampa]

I guess there isn't an answer here. Why would MS allow you to use add-ins without being able to protect them? They must have thought of a way.