MS Excel 2010 VBA error
Clash Royale CLAN TAG#URR8PPP
MS Excel 2010 VBA error
I am new to Excel VBO, I have created a button, now when I am trying to click on the button getting the error as
Cannot run the macro. The macro may not be available in this workbook
or all macros may be disabled.
I have already enabled the setting in Trusted Center also.
Any suggestion will be helpful
Thanks in advance
vbo
excel-vba
Could you edit your question (edit button just under the tags) and include the code you've used and also add where the code is - on the right of the VBA code is a window called Project Explorer listing all the open workbooks, worksheets and modules in those workbooks. Is the code in a worksheet, module, class module, ThisWorkbook?
– Darren Bartrup-Cook
Aug 6 at 9:32
Is this a Form Button, or an ActiveX Button? (If you can only right-click on it with "Design Mode" enabled, then it's an ActiveX button and the Macro needs to be in the Worksheet instead of a module)
– Chronocidal
Aug 6 at 10:58
1 Answer
1
Thank you all.
Problem solved, Just removed the previously created button and created it again this solved the issue and restarted the excel also.
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
I don't think tag
vbo
applies to your question. Perhaps you meant to use tagexcel-vba
instead?– TT.
Aug 6 at 8:06