Coping command button

[hoyos]

I have copied a command button and paste it in another sheet. I have managed to change the name but the macro won’t work. When right clicking the button I don’t get properties in the drop down box. Is there another way of accessing properties for the command button?

 

[Fluff]

In that case I see no reason why it shouldn't work. In what way isn't it working & do you get any error messages?

 

[Fluff]

Another thought, where is the code located, is it in a standard module, or a sheet module?

 

[hoyos]

In that case I see no reason why it shouldn't work. In what way isn't it working & do you get any error messages?

Button1 is not showing current period it's stuck on "0" I,ve tried sending you a copy using XL2BB but it doesn't show the buttons. Any idea how to get over this?

 

[Fluff]

What is in AB18 & also can you answer my question from post#12, which you may not have seen, as we posted at the same time.

 

[hoyos]

 

[hoyos]

It’s in a standard module. Each period is 28 days and we have 13 periods over a year, AB18 is the reference cell for button1 to indicate which is the current period is displayed.

 

[Fluff]

I can see no reason why the button would show 0, Is it the "PeriodBefore" code that si attached to Button1?

 

[hoyos]

I can see no reason why the button would show 0, Is it the "PeriodBefore" code that si attached to Button1?

When you press either PeriodBefore or PeriodAfter that number should increase or decrease. I don’t understand why it’s not working. It does on other sheets only on one it doesn’t. I’m confused.com!!

 

[Fluff]

Is the correct code still assigned to the button?

 

[hoyos]

Is the correct code still assigned to the button?

Yes it is. Just had a thought the original button disappeared that’s why I copied the button from another sheet and pasted it on the sheet I’m working on that may be the reason why it’s not working. Your thoughts?