For one column we have used addType validation. Below is the syntax we have used.
.Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0", Formula2:="999999999999999999"
The same is working fine when we don't protect the sheet. However for project constraints we are protecting the workbook & the work sheet due to which we are getting the error as below.
object invoked has disconnected from its clients.
Please help us to inorder to overcome the above mentioned error.
Thanks & Regds
Kaywin
.Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0", Formula2:="999999999999999999"
The same is working fine when we don't protect the sheet. However for project constraints we are protecting the workbook & the work sheet due to which we are getting the error as below.
object invoked has disconnected from its clients.
Please help us to inorder to overcome the above mentioned error.
Thanks & Regds
Kaywin