Commandbutton

I created a commandbutton in an earlier version of Excel and I cannot get it to run anymore with the Office 365 package. It is a simple button to hide/unhide certain columns; I think the association of the between the MACRO and command button is lost. I can no longer access the propeorties of the command button.

Here is what I had programmed in the sheet:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Your description says command button but the comment in the code says toggle button. The code looks like it would only work for a toggle button.

If it's a toggle button, it's probably an ActiveX control. A Windows update late last year inadvertently caused ActiveX controls to stop working. A fix for this is to search for and delete files named MSForms.exd. I have done this on three computers with no side effects. However, I do not know for sure that is your problem.

I am not familiar with running Excel under Office 365 so I don't know how that might come into play.

The best way to diagnose this is with your file. Can you attach it?

By the way this code can be streamlined. The variable Act is never used, so its declaration can be removed. You are setting a Boolean attribute that is directly dependent on a Boolean value, so that logic can be simplified. Such is the beauty of a toggle button.

Please Login or Register  to view this content.