Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2018, 02:54 AM
Debaser's Avatar
Debaser Debaser is offline Pass sheet protected argument to Ribbon Control Windows 7 64bit Pass sheet protected argument to Ribbon Control Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Why are you replicating a built-in control instead of just taking it over?
Reply With Quote
  #2  
Old 03-20-2018, 04:24 AM
BartH BartH is offline Pass sheet protected argument to Ribbon Control Windows 10 Pass sheet protected argument to Ribbon Control Office 2016
Novice
Pass sheet protected argument to Ribbon Control
 
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
Reply

Tags
excel vba, ribbon control, sheet status



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pass Arguments to Function Through Ribbon inagalaxyfarfarawry Word VBA 11 03-25-2022 09:28 PM
Pass sheet protected argument to Ribbon Control Errors in macro when sheet protected ernief Excel Programming 2 11-18-2016 03:35 AM
Pass sheet protected argument to Ribbon Control Using combobox to pass data from an Excel spread sheet to text boxes on userform Stewie840 Word VBA 14 12-17-2015 10:13 PM
Pass sheet protected argument to Ribbon Control creating a content control that is password protected kawtharz Word VBA 5 08-21-2015 12:50 AM
Autoexpand Table on Protected Sheet Catalin.B Excel 0 09-07-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft