Thread: Pass sheet protected argument to Ribbon Control
View Single Post
 
Old 03-20-2018, 04:24 AM
BartH BartH is offline Windows 10 Office 2016
Novice
  
Join Date: Mar 2018
Posts: 7
BartH is on a distinguished road
Default
Quote:
Originally Posted by Debaser View Post
Why are you replicating a built-in control instead of just taking it over?
Hi Debaser,

Because the Protect Sheet control would require entering the password when (re-)protecting the sheet and in my code (doProtectSheet) the password is pre-programmed (when it is a foreign file with an unknown password, the password will be requested and stored).

Grtz Brt
Reply With Quote