Pass sheet protected argument to Ribbon Control

Debaser · #1 03-22-2018, 08:10 AM

If you're repurposing a command, the callback procedure declaration has to be slightly different, so that you can specify whether to allow the default action to run too:

Code:

Sub cbDoProtectSheetRepurpose(control As IRibbonControl, ByRef cancelDefault)
cancelDefault = True
doProtectSheet
End Sub

BartH · #2 03-22-2018, 09:12 AM

Quote:

Originally Posted by Debaser

If you're repurposing a command, the callback procedure declaration has to be slightly different, so that you can specify whether to allow the default action to run too:

Code:

Sub cbDoProtectSheetRepurpose(control As IRibbonControl, ByRef cancelDefault)
cancelDefault = True
doProtectSheet
End Sub

ThnX Debaser, I got it!

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