| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning if other files open
Thanx.
"Gary''s Student" wrote: Sub mikef() n = Workbooks.Count If n 1 Then MsgBox ("WARNING!!!" & Chr(10) & "There are " & n & " workbooks open!!") End If End Sub -- Gary''s Student - gsnu200824 "MikeF" wrote: Need a "warning" MsgBox, saying that another Excel file is open and do I wish to close it before proceeding, and if yes then close without saving. In other words, if ActiveWindow.ActivateNext goes anywhere other than the current file, that warning should pop up. Thanx, - Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Warning when I try to open ecxel in 2007. | Excel Discussion (Misc queries) | |||
| Number add-in warning comes up when opening files | Excel Discussion (Misc queries) | |||
| Warning before saving files! | Excel Discussion (Misc queries) | |||
| Excel file already open warning | Setting up and Configuration of Excel | |||
| Playing .wav files (why do a few cause warning messages?) | Excel Programming | |||
![MikeF[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
