Problem with excel security settings causing UserInterFaceOnly to not work

[gazza365]

Hi,

I have a workbook that has the following code in the "This Workbook" page

Please Login or Register  to view this content.

This code protects every sheet but allows macros to run. It seems to work fine when I open the workbook from my documents as this is a trusted source in my excel settings.

The problem is that when I send it to other users, the excel security warning that disables 'Active content' etc seems to stop this from working properly. Even if the user clicks 'enable this content', they get 'run-time error 1004 - unable to set the Hidden property of the Range class'

As I understand it, the UserInterfaceOnly: = True code allows macros to run on protected sheets. It appears that the excel security settings that initially prevent the macros from running has also prevented my workbook open event from running.

Any idea how to stop this? The workbook has a lot of macros so adding in an 'Unprotect - protect' to each one would be very impractical.

Thanks in advance for any help.

Gareth

[JBeaucaire]

You can't "make" people turn on macros to see/use your sheets. You can only ask them to.

Many people make it unfruitful for people to disable macros by causing the workbook that opens with no macros enabled be useless. The most common trick being to hide all sheets in the workbook except a single "splash screen" sheet with nothing more on it than a message saying "Macros are disabled thus nothing will appear in this workbook."

If macros are enabled, the wb_open events would include action that unhides all the activity sheets and hides the "splash screen sheet".

If you Google "Excel VBA Force Macros" you'll find 100s of ready to try explanations/solutions.

[royUK]

It seems to be a problem in your code, without seeing the workbook & code it's difficult to assess