ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open Workbook to Protected/Read-only Warning (https://www.excelbanter.com/excel-discussion-misc-queries/223598-open-workbook-protected-read-only-warning.html)

JSnow

Open Workbook to Protected/Read-only Warning
 
Whilst playing around with vba making macros and worksheet subs, I must have
done something that triggers the following warning upon opening the workbook:

The cell or chart you are trying to change is protected and therefore
read-only.
To modify a protected cell or chart, first remove protection using the
Unprotected Sheet command (Tools menu, Protection submenu).

I have to click the OK button anywhere from 5 to 11 times (the workbook has
16 sheets). I'm wondering why this started showing up. I'll gladly post any
code if it will help. I can tell you that I have nothing in the ThisWorkbook
sheet.


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com