Running Macro in Read Only Workbook

[katmarie]

Hello All

I maintain a workbook that is saved on a network drive so that others have read access only, and I have full access.

The workbook is configured with a macro that forces users to Enable Content via a splash sheet when the document is opened. I have created the macro using the following tutorial/code: Make Users Enable Macros in Order to View a Workbook in Excel - TeachExcel.com

[ICODE]Private Sub Workbook_Open()[/ICODE]

[ICODE]'worksheets to show when macro is enabled[/ICODE]

[ICODE]Sheets("Data").Visible = True[/ICODE]

[ICODE]'worksheet that shows reminder to enable macro[/ICODE]

[ICODE]Sheets("Reminder").Visible = xlVeryHidden[/ICODE]

[ICODE]End Sub[/ICODE]

[ICODE]Private Sub Workbook_BeforeClose(Cancel As Boolean)[/ICODE]

[ICODE]'worksheet with reminder[/ICODE]

[ICODE]Sheets("Reminder").Visible = True[/ICODE]

[ICODE]'worksheets to show when macro is enabled[/ICODE]

[ICODE]Sheets("Data").Visible = xlVeryHidden[/ICODE]

End Sub

The macro runs fine for me when I open the document due to having full access, however others in my team do not get the "Reminder" page when the document is opened. Assuming I need some sort of code to force the Reminder page to be shown even if the document is opened in Read Only?

Any help would be great!

Kat

 

[Colo]

Hi,

Macros should basically work even if they open the file in the Read Only mode. Of course, they cannot save it, but they can run the macro. However, if they don't have access rights, of course, the macro doesn't work as intended. It may be that the access rights have not been set properly.

Just an idea. How about every time saving the document showing the "Reminder" page (when you save the book) so that others in your team can see that page when they open the file even in Read-Only mode or macro is disabled?