disable macro for user in read only mode

[maacmaac]

I have a workbook with 10 different macros. If a user opens the spreadsheet in read only mode, I want to deny access to one of the 10 macros available. If the user trys to run this macro, I just want a simple warning message box saying access denied for this one single macro. Is this possible? Thanks in advance for any comments.

[KiPA]

This should do the job when added in the very beginning of the code:

Please Login or Register  to view this content.