98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » I have problem with Excel 2010
I have problem with Excel 2010
Resolved · Urgent Priority · Version 2010
Fri 7 Dec 2012, 12:10Delegate Tony said...
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
Mon 10 Dec 2012, 10:22Trainer Gary said...
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
Thu 13 Dec 2012, 11:44Trainer Cindy said...
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.
Mon 23 Sep 2019, 09:57enerkeylog (guest) said...
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/
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Excel 2010 Shortcuts - Start and End of the WorksheetDid you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard? |
