Pass sheet protected argument to Ribbon Control

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Pass sheet protected argument to Ribbon Control

FAQ

Thread Tools

Display Modes

03-20-2018, 04:24 AM

BartH

Windows 10 Pass sheet protected argument to Ribbon Control

Office 2016

Novice

Join Date: Mar 2018

Posts: 7

Quote:

Originally Posted by Debaser

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

Tags

excel vba, ribbon control, sheet status

« Previous Thread | Next Thread »

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
Errors in macro when sheet protected	ernief	Excel Programming	2	11-18-2016 03:35 AM
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
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 12:17 AM.