Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
Make Workbook Password protected tp open | Excel Discussion (Misc queries) | |||
Need VBA Code to Open a Workbook in read only | Excel Discussion (Misc queries) | |||
How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
Can a footer be protected or read-only? | Excel Discussion (Misc queries) |