Macro won't run on password protected workbook

**royUK** · Jan 12th 2021

Checked Enable all macros - not a good idea, you should require a warning about macros
Message Bar. Checked Never show information about blocked content - I would uncheck this

troy11 · Jan 12th 2021

OK I will do so.

**royUK** · Jan 12th 2021

Is the problem just in the one workbook?

troy11 · Jan 12th 2021

I thought it may be, but I did try to start from scratch yesterday and still had the same issue.

**royUK** · Jan 12th 2021

Does this affect any other workbooks?

troy11 · Jan 12th 2021

I only have a password on 1 workbook, so I don't know.

**royUK** · Jan 12th 2021

I don't think the password can be causing the issue

troy11 · Jan 12th 2021

OK, I did run the macro though when the password was removed. When the password was re-entered, it was the same issue.

Maybe it's not the password but indirectly it's causing the issue.

Participate now!