Updating OLD code
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()
"Mike Q." wrote:
ActiveSheet.Unprotect
--
Mike Q.
"SanInTexas" wrote:
I am trying to update an old XLM macro.
Eventually-I'll redo it. But for now, does anyone know the command to
unprotect a protected sheet?
Thanks...
|