J
JK
Please allow me to ask two questions:
(1) Which is the most fail-safe way to write in procedures: ThisWorkbook or
ActiveWorkbook?
Moreover, assuming it is ThisWorkbook, would I be required to write
Dim mySheet As Worksheet
Set mySheet= ThisWorkbook.Sheets(1)
Or can I simply write
Set mySheet=Sheets(1)
(2) I have a Clear Forms button on my toolbar that makes cell.Value="" on a
number of different sheets. Can I include Application.EnableEvents at top
and bottom as such,
Sub ClearForms()
Application.EnableEvents=False
With Sheets(1)
[code to clear cells]
End With
[additional With statements]
Application.EnableEvents=True
End Sub
or,
is it better to include it for each sheet action as such,
Sub ClearForms()
With Sheets(1)
Application.EnableEvents=False
[code to clear cells]
Application.EnableEvents=True
End With
[additional With statements]
End Sub
I'm just trying to make my application as bullet-proof against Excel quirks
as possible (if there is such a thing). Thank you in advance.
Jim Kobzeff
(1) Which is the most fail-safe way to write in procedures: ThisWorkbook or
ActiveWorkbook?
Moreover, assuming it is ThisWorkbook, would I be required to write
Dim mySheet As Worksheet
Set mySheet= ThisWorkbook.Sheets(1)
Or can I simply write
Set mySheet=Sheets(1)
(2) I have a Clear Forms button on my toolbar that makes cell.Value="" on a
number of different sheets. Can I include Application.EnableEvents at top
and bottom as such,
Sub ClearForms()
Application.EnableEvents=False
With Sheets(1)
[code to clear cells]
End With
[additional With statements]
Application.EnableEvents=True
End Sub
or,
is it better to include it for each sheet action as such,
Sub ClearForms()
With Sheets(1)
Application.EnableEvents=False
[code to clear cells]
Application.EnableEvents=True
End With
[additional With statements]
End Sub
I'm just trying to make my application as bullet-proof against Excel quirks
as possible (if there is such a thing). Thank you in advance.
Jim Kobzeff