Hello All,
When using Option Explicit at the top of a module, is the use restricted to public modules? Or is it supposed to work for modules that are specific a worksheet. For example, if I place this at the top of a Worksheet module ...
Are those variables supposed to then be declared for all subs in that module, even though those subs are Private Sub ... ?
I get variable not declared errors doing this.
When using Option Explicit at the top of a module, is the use restricted to public modules? Or is it supposed to work for modules that are specific a worksheet. For example, if I place this at the top of a Worksheet module ...
VBA Code:
Option Explicit
Public shtprotect As Boolean
Public endprotect As Boolean
Are those variables supposed to then be declared for all subs in that module, even though those subs are Private Sub ... ?
I get variable not declared errors doing this.