Looking for a good way to get people to enable macros?

[tonywatsonhelp]

Hi Everyone,

I have a simple document that goes out to new employees that they fill in.
To make it simple I've hidden all the tabs formula bars headers etc

But many people are coming back saying they cant get it to work because it has macros and excel disables them.

Is there a way to either get my macros trusted so the document will open with macros enabled or Make it clear to people that macros must be enabled before proceeding.

I apreciate this is a bit vague but I'm open to all ideas that might help

Thanks

Tony

 

[PatOBrien198]

maybe, as a default, hide all of the sheets except one, which has a screen print or instructions of how to enable macros.

maybe even make them "veryHidden" before sending out so they can't un-hide them manually.

Then, if macros ARE enabled, when the workbook is opened, hide that one sheet and make visible the other sheets you need.