EuSprig - Data Validation and Form Controls to restrict user inputs

preview_player
Показать описание
Submission for European Spreadsheet Risk Group Annual Conference - An Introduction to Data Validation and Form Controls to restrict user inputs to Excel Spreadsheets and workbooks
  1. Paula's Web3 & Crypto
Рекомендации по теме
EuSprig - Data 0:18:49

EuSprig - Data Validation and Form Controls to restrict user inputs

Spreadsheet Risk: What 0:29:34

Spreadsheet Risk: What Risk? [WEBINAR]

EuSpRIG 2020 – 0:38:04

EuSpRIG 2020 – Comparing options for building an audit sampling template in Excel

Spreadsheet Detective: The 0:03:49

Spreadsheet Detective: The Case of the Invisible Spreadsheet Errors

How To Reduce 0:43:02

How To Reduce Spreadsheet Risk in Microsoft Excel [WEBINAR]

Building Error Checks 1:00:22

Building Error Checks in Financial Models (Webinar)

I've been working 0:11:57

I've been working with Excel for 30 YEARS. Here are my 10 steps for building great spreadsheets

Managing Spreadsheet Risk 0:59:31

Managing Spreadsheet Risk in Financial Models

Excel Curation Corner 0:08:11

Excel Curation Corner #4- Sharing the best Excel blogs & Videos

Advanced Excel Audit 0:16:16

Advanced Excel Audit LO 07 May2312

Simon Thorne | 0:00:39

Simon Thorne | TEDxAberystwyth 2020 speaker announcement

Inventory Audits and 0:15:59

Inventory Audits and Stocktaking Locally and Globally in Real-Time

Introduction to Row 0:01:21

Introduction to Row Hierarchies in Spreadsheet.com

October 24th 2012 0:28:18

October 24th 2012 Part1

JOTB19 - Crossing 0:45:40

JOTB19 - Crossing the bridge by Mark de Brauw

Advanced Financial Modeler 1:36:30

Advanced Financial Modeler Certification: Best Practices in Spreadsheet Modeling

DAMA International Presents: 1:01:09

DAMA International Presents: Data Governance for End User Computing

CIS114 DE 10 0:54:13

CIS114 DE 10 13 2020

Excel Toronto Meetup 1:17:03

Excel Toronto Meetup Group - Can you trust your spreadsheets?- Patrick O'Beirne

Excel 2013 Accounting 1:19:49

Excel 2013 Accounting Tricks for Excel CPE Credit at Poodle Dog Restaurant (50 Examples)

'End-User Software Engineering: 0:59:03

'End-User Software Engineering: Beyond the Silos,' Margaret Burnett, SIGSOFT

Sorting text and 0:13:10

Sorting text and comparing

Dr Nitin Paranjape 1:25:37

Dr Nitin Paranjape Webcast Part1

Dr Nitin Paranjape 2:43:42

Dr Nitin Paranjape session 2- P.H.TEKNOW PVT LTD. Customer training

Комментарии
Автор

Hi Paula, very nice and comprehensive lesson on data validation and form controls to restrict user input. As you pointed out, one weakness is that the user can copy and paste over your validation rule, although there are ways to protect against this with VBA. Too bad that Microsoft does not allow for no copy/paste as an option when defining the rule. Seems like it would be something simple for them to add. Anyway, always enjoy your videos and learn something new each time. Thanks and thumbs up!

wayneedmondson
welcome to shbcf.ru