Tony has attended:
Excel Advanced course
Excel Advanced - For Power Users course
I have problem with Excel 2010
Hi there,
I need your help.
I practiced recording macro when I received training 3 weeks ago but I think something went wrong with my excel/macro.
Usually I export payroll data from Sage payroll into excel but there is message appear on the screen:
"Current security settings prevent list being sent to Microsoft Excel. To send the list to Microsoft Excel the "Macro Security" setting must be modified so that 'Trust access to Visual Basic Project' is checked"
Could you please so kind to help me solve this problem?
How to delete recording macro?
Kind regards,
Tony
RE: I have problem with Excel 2010
Hi Tony
Thanks for getting in touch. To enable this, complete the following:
Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. In here you will see a checkbox for "Trust access to the VBA project model".
I hope that fixes your problem.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
RE: I have problem with Excel 2010
Excel error is a very critical thing that affects our work. I also faced the same macro error in my excel sheet. But could did not get the proper solution. I faced different types of error and I think excel users also faced different excel error. Recently I faced another excel issue . Suddenly MS Excel Has Stopped Working. For that reason, I could not finish my valuable project. But I found a solution by a browsing site.https://msofficetechnicalsupportnumbers.com/blog/how-to-fix-ms-excel-has-stopped-working-error/
