CODEWITHSUNDEEP
excelvba
Zepfanman
Zepfanman

Reputation: 3

Disallow workbook editing unless Enable Content is clicked

I'm setting up a shared Excel spreadsheet with macros, but I don't want to let anyone edit the document at all until they've clicked the "Enable Content" in the SECURITY WARNING bar at the top.

How can I "protect" the workbook like that?

Upvotes: 0

Views: 675

Answers (1)

teylyn
teylyn

Reputation: 35915

Set up the workbook to run a macro before the file is saved (workbook.beforesave). In that routine, set all sheets to xlVeryHidden, except for one sheet where you explain that the user needs to enable macros. You could even have a screenshot showing what they need to click.

When macros are enabled, the workbook_open event can unhide all sheets you want to show.

Protect the VBA project with a password.

Someone with very malicious intent and advanced coding skills will probably be able to find a way to circumvent this setup, but it should work well in a business environment where people just want to get their work done.

Upvotes: 2

Related Questions