| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msgbox in worksheet activate event if design mode is turned off
Hello all,
Code given below pops up a msgbox whenever any sheet in the workbook is activated. How to tweak this code to make the msgbox to pop-up only if design mode is turned off. Private Sub Workbook_SheetActivate(ByVal sh As Object) MsgBox "Please check if the design mode is turned off", vbInformation, "Excel" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks Inserted in Design Mode inactive once Exited Design Mod | Excel Programming | |||
| Worksheet Controls in design mode | Excel Programming | |||
| Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
| MsgBox execution sends program into design mode | Excel Programming | |||
| Enter Excel Design Mode and Exit Design Mode | Excel Programming | |||
![Thulasiram[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
