Thread: not calling
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default not calling

If the macro is in the standard module, it should run. I don't even use Call
for mine. I just put the procedure name on a line and it runs, so you either
have the macro as a private sub or there is some other disconnect.

"Curt" wrote:

will someone tell me why this does't call the macro. This is in the code for
a user form. It is acessed by an option button. Do I need to put the macro
procedure into the code of the option button?
Thanks

Private Sub OptionButton30_Click()
'Announcer Cards
Call AAAA
Worksheets("Data").Range("A4:A100,D4:D100,E4:E100, G4:G100,L4:L100").Copy
Worksheets("Announcer").Range("A2").PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
'Destination:=Worksheets("Announcer").Range("A2")
End Sub