Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing "AllowEditRange" without unprotecting sheet
I have a function written designed to write data into a templat (another excel file) -- it'll save me tons of time, but here's th problem: The excel spreadsheet I'm writing to has locked "AllowEditRange" -- t which I know the password -- but the sheet itself is locked, and don't know the password for that. I cannot seem to find any way to programmically unlock the range vi the password I'm given -- most ideas I've had have been thwarte because the cell is locked -- TrevelPosted from http://www.pcreview.co.uk/ newsgroup acces |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting/Unprotecting all sheets with macro leads to "image" iss | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Unprotecting 4 sheets before "WorkbookOpen" macro runs | Excel Discussion (Misc queries) | |||
"Library not registered" message accessing an HTMLDocument object | Excel Programming | |||
Accessing a "veryhidden" sheet | Excel Programming |