Ad free CAclubindia and daily updates on your mobile. Subscribe Now!

EASYOFFICE

EASYOFFICE

EASYOFFICE

Macro

(Guest)

HW TO MAKE EXCEL SHEET MACRO UNABLE

Reply
Follow
Share

3 Replies

(Guest)

You can enable macros in Excel by setting your Excel Security Level:

Office 2000-2003:
Menu :: Tools :: Macros :: Security.
Office 2007:
Microsoft Office Button :: Excel Options :: Trust Center :: Center Settings :: Macro Settings.

You can set Security to High, Medium or Low:

High Security.
All Excel macros (except from trusted sources) are disabled.
Medium Security.
User is prompted on each file-open to enable or disable Excel Macros
Low Security.
Excel Macros can run automatically without a prompt. You are not protected from potentially unsafe macros

Choose - Disable all macros with notification

Upgrade to CAclubindia Pro. Subscribe Now!

Jaideep (Service) (1368 Points)
Replied 13 May 2011

Thanks for Sharing

(Guest)

If anyone needs macro to be written please contact me.

Join CCI Pro

Recent Topics

More recent discussions | Post

Related Threads

Popular Discussion

Start a New Discussion

EasyOFFICE

CCI Pro

Trending Online Classes

Certification Course on Chat GPT and AI Tools for Professionals

CA Deepak Gupta

Enroll Now

21 October 2024
GST Live Certification Course (40th Batch)(With Certificate)

CA Arun Chhajer

Enroll Now

17 November 2024
Live Course on Invoice Management System (IMS) - 2nd Batch(With Recording)

CA Arun Chhajer

Enroll Now

13 October 2024

view all classess

Subscribe to the latest topics :

Search Forum:

Forum Home

Popular Threads

Recent Posts

Unreplied Threads

Settings