Suddendly having a problem with writing a sub
The Sub does not appear on the VB worksheet
steps
1. Developer tool bar turned on
2. Design Mode
3.Insert Active X Controls Command button
4. Place command button on worksheet
5. Properties take focus--false
6. View code
In the past I get a sub with the name that is in the Command Button
However now the VBA code page appears with the cursor at the top of page but no sub identified.
Expect
Sub (Name in command button)
End sub
If there are other subs on that page it would appear at bottom of those
Now the curser appears at top of page no matter what is there.
I've reloaded Office 2010
Can't think of a step that I have missed --have written numereous subs in past with above process
Thanks for your help