Excel VBA - Question about Syntax and the Language Structure
Posted on 2013-11-24
To protect and unprotect a sheet you write:
So, how come the same rule doesn't apply to displaying page breaks? How come you have to write:
Sheet2.displayPageBreaks = True
Sheet2.displayPageBreaks = False
The following would make more sense given the grammar of the protect/unprotect statements.
I'm trying really hard to get a philosophical grip on the grammar of VBA and it's quite a chore. I'm looking for some threads of logic as to when I need to use "=true" or when I need to type a subscript like worksheets ("sheet1")
OR, do I just need to bite the bullet and memorize these language conjugations.