G
Guest
Sheet1:
It contains a form and a button "Save" where users can input information
(data validation present on some cells).
Sheet2:
Whenever the "Save" button is clicked from Sheet1, it automatically
populates a row in Sheet2. Both sheets protected. My code is actually
working perfectly fine-
The Problem:
It's just that- ideally this form SHOULD BE SHARED, but whenever I try to do
that, I get the error message "Run-time error '1004': Method 'Unprotect' of
object'_Workbook' failed"
Is there a way to remedy this error? What needs to be done?
Please help.
It contains a form and a button "Save" where users can input information
(data validation present on some cells).
Sheet2:
Whenever the "Save" button is clicked from Sheet1, it automatically
populates a row in Sheet2. Both sheets protected. My code is actually
working perfectly fine-
The Problem:
It's just that- ideally this form SHOULD BE SHARED, but whenever I try to do
that, I get the error message "Run-time error '1004': Method 'Unprotect' of
object'_Workbook' failed"
Is there a way to remedy this error? What needs to be done?
Please help.