Hi Experts,
I am getting following error while running macro. Run-time error '1004':
Unable to get the Add property of the Buttons class
Sub Macro3()
'
' Macro3 Macro
'
'
Sheets("Discount form").Select
ActiveSheet.Buttons.Add(448.8, 58.8, 101.4, 72).Select
Sheets("Discount form").Copy
Application.Dialogs(xlDialogSendMail).Show
End Sub
What I am trying to do is:
1. Record Macro
2. Right click tab "Discount form"
3. Select Move and copy
4. To book: (new book)
5. Tick Create a copy
6. Ok
7. In new book, File> Share > Email > Send as Attachment
8. Macro Stop
Note : Column O & P are hidden with password protected.
I am getting following error while running macro. Run-time error '1004':
Unable to get the Add property of the Buttons class
Sub Macro3()
'
' Macro3 Macro
'
'
Sheets("Discount form").Select
ActiveSheet.Buttons.Add(448.8, 58.8, 101.4, 72).Select
Sheets("Discount form").Copy
Application.Dialogs(xlDialogSendMail).Show
End Sub
What I am trying to do is:
1. Record Macro
2. Right click tab "Discount form"
3. Select Move and copy
4. To book: (new book)
5. Tick Create a copy
6. Ok
7. In new book, File> Share > Email > Send as Attachment
8. Macro Stop
Note : Column O & P are hidden with password protected.