Command Bar - Changing a variable's property?

Hi, In my ongoing battle to create this simple add-in for work.

I've now decided to toggle the reminder on and off using a command button inside a command bar, this is the code I have below.

Please Login or Register  to view this content.

Response is a boolean, I've tried all sorts to get this to work and it returns the same error each and every time "Cannot run the macro "pathname". The macro may not be available in this workbook or all macros may be disabled.

How do you overcome this problem?

EDIT: Also whilst on the same topic, Is there anyway for me to show some sort of label showing the status of response?

Is this: Private Sub App_WorkbookOpen(ByVal Wb As Workbook) meant to be the Workbook Open event. Or do you call it from the Workbook Open event?

If it's meant to be the Workbook Open event, it isn't. If it is called from the Workbook Open event, it should be in a standard module.

This worked for me:

Please Login or Register  to view this content.

Regards, TMS

So, do you dim App and set it in the Workbook Open? I don't think you'd normally need to do that unless you're trapping events out of the norm, like creating a New Workbook.

In all honesty, I've never needed it ... maybe I'll look for an opportunity to use it but I haven't actually needed it.

When you try something you think should work and it doesn't, maybe try the thing that you don't think should work but you're told it does


Regards, TMS

Originally Posted by TMShucks

So, do you dim App and set it in the Workbook Open? I don't think you'd normally need to do that unless you're trapping events out of the norm, like creating a New Workbook.

In all honesty, I've never needed it ... maybe I'll look for an opportunity to use it but I haven't actually needed it.

When you try something you think should work and it doesn't, maybe try the thing that you don't think should work but you're told it does


Regards, TMS

Just gave that a try, didn't work .

in this workbook i have the following line of code.

Please Login or Register  to view this content.

And that's all really.

EDIT: I've just tried creating a module and moving the following code into it

Please Login or Register  to view this content.

This now makes the menu work, however over functions that are in the class module that rely response now aient working - and It wont let me debug to find out why.

Please Login or Register  to view this content.

I have the following public variables declared in the class module..

Please Login or Register  to view this content.

You haven't defined it the way it says on Chip's web site ... but you really don't need it, at least not for this specific task.

See the attached workbook.

Regards, TMS

Please post the workbook.

You're welcome. Thanks for the rep.

Can I just ask, when you say "I have the following public variables declared in the class module.", what do you mean by that? Which Class module?

Thanks for sharing your final code. I must have a play with this! Looks like hours of fun

So, you really DID mean a Class module.

Regards, TMS