I have a macro enabled workbook. It has protected worksheet and workbook. Workbook includes 3 Sheets. Sheet1 named as Main Sheet2 named as Tab2 Sheet3 named as Tab3

I have disabled cells on Tab2 and I have a macro that should throw prompt to user enable cells or not. If User selects "yes" cells gets enabled and drop down on "Main" sheet will be changed to yes.

Macro works fine for me. I have to share the workbook to the other users via e-mail.

Users saves the workbook on his machine and selects "Enable Editing" and "Enable Macros".

But the Workbook name at the top shows XXXX[Read-only] and cells are Tab2 are not getting enabled when users clicks "ok" on the prompt.

Do I have an option to open the workbook Read/Write mode? Or any other option for me so that protection works fine? 

Please Login or Register  to view this content.