Log In
Register
Home
issue with Macro
Aye Mu
Member
Members
Forum Posts: 201
Member Since:
December 22, 2018
December 22, 2018
Offline1
August 10, 2021 - 5:58 pm
Hi Team,
I have an excel report with macro enabled. I tried to open that and came across the following message. I tried enabling macro and search for help. But no luck.
Please let me know other area I should check.
Thank you.
See Answer
Philip Treacy
Admin
Forum Posts: 1619
Member Since:
October 5, 2010
October 5, 2010
Offline2
August 11, 2021 - 4:33 pm
Hi,
When you open a workbook containing macros you should get a default warning towards the top of the screen (under the Ribbon) asking you if you want to enable macros. Say yes.
In case you have macro security set to be disabled without notification. you'll need to go into
File -> Options -> Trust Center -> Macro Settings
and set them to 'Disable VBA macros with notification'
Regards
Phil
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Waqas Arshad
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
Forum Stats:
Groups: 3
Forums: 25
Topics: 7157
Posts: 31386
Member Stats:
Guest Posters: 50
Members: 34656
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —