LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default ThisWorkbook vs. ActiveWorkbook?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveWorkbook.RefreshAll teepee[_3_] Excel Discussion (Misc queries) 0 November 11th 08 02:11 PM
ActiveWorkBook Pete Excel Discussion (Misc queries) 3 May 9th 05 04:14 PM
ActiveWorkbook.RefreshAll toosie Excel Programming 1 February 16th 05 09:55 AM
ActiveWorkbook.Close dallas Excel Programming 0 November 3rd 04 06:27 PM
Activeworkbook.Saved Jack Clift Excel Programming 4 February 5th 04 08:42 AM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"