smiths / MEASURE-Doc

For Issue Tracking of MEASURE 2.0
Other
2 stars 0 forks source link

Rubric Input Template Measurement Date Format #267

Closed arana2 closed 4 years ago

arana2 commented 4 years ago
arana2 commented 4 years ago
arana2 commented 4 years ago

desired_date_format vba_detail_error_message vba_error_message

arana2 commented 4 years ago
arana2 commented 4 years ago

Steps to changing the date format without the VBA error appearing

  1. Create a copy of the template (so you're not working with the production version)
  2. Unprotect Sheet 2a. Actions --> Unhide 2b. Hiding all dynamics is no longer needed, as this action throws the VBA error
  3. Update Date format to YY/MM/DDDD
  4. Actions --> Hide
  5. Protect Sheet
  6. Save Template image