Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
ActiveWorkBook | Excel Discussion (Misc queries) | |||
ActiveWorkbook.RefreshAll | Excel Programming | |||
ActiveWorkbook.Close | Excel Programming | |||
Activeworkbook.Saved | Excel Programming |