Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() This is the syntax from "Microsoft Excel Function Reference - 1992" ... Protect.Document(contents, windows, password, objects) Arguments are all Boolean except for password. If the Boolean arguments are all false, then the sheet is unprotected. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "SanInTexas" wrote in message Thanks. I know that works for a current macro; however, this is an old spreadsheet macro as follows: Record3 (g) =ECHO(FALSE) =ACTIVATE("[Xsphere40.xls]Input Sheet") =SELECT("R13C18:R18C18") =COPY() =SELECT("R5C2") =PASTE() =FORMAT.FONT(,,TRUE) =ALIGNMENT(2,FALSE,3,0) =BORDER(0,1,0,0,0,,,0) =BORDER(0,1,1,0,0,,,0,0) =BORDER(0,1,1,1,0,,,0,0,0) =BORDER(0,1,1,1,1,,,0,0,0,0) =VIEW.SHOW("inp") =ECHO(TRUE) =RETURN() |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating Charts by a VBA code | Excel Programming | |||
DDE links not updating after stepping into VBA code | Excel Programming | |||
Updating Excel Code | Excel Programming | |||
Updating Source Code in Charts | Charts and Charting in Excel | |||
Updating VB Code | Excel Programming |