Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect a Worksheet
I have a worksheet that has a parameter query that was set up through the
Import External Data option. It is set to refresh on open and it errors out if I protect the worksheet and save it. I have tried protecting the worksheet with code but can't seem to find the correct place to put the code. I tried it in "This Workbook" but it protects it before the query runs and does the update. I have put the protect in the begining of the worksheet that I want to protect but it does not protect it. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
How to protect worksheet? | Excel Programming | |||
protect the worksheet | Excel Worksheet Functions | |||
Protect Worksheet Help! | Excel Programming | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) |