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-22-2018, 08:10 AM

Debaser

Windows 7 64bit Pass sheet protected argument to Ribbon Control

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

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

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 08:22 AM.