文書番号: 402468
最終更新日: 1997/10/20
Sub Only_Sheet1() Worksheets("sheet1").OnSheetActivate = "Menu_Enabled_False" Worksheets("sheet1").OnSheetDeactivate = "Menu_Enabled_True" End Sub Sub Only_Sheet1_Reset() Worksheets("sheet1").OnSheetActivate = "" Worksheets("sheet1").OnSheetDeactivate = "" Worksheets("sheet1").Select End Sub Sub Menu_Enabled_False() For Each mn In ActiveMenuBar.Menus mn.Enabled = False Next mn End Sub Sub Menu_Enabled_True() For Each mn In ActiveMenuBar.Menus mn.Enabled = True Next mn End Sub
Sub Only_Sheet1() On Error Resume Next Worksheets("sheet1").OnSheetActivate = "Menu_Enabled_False" If Err <> 0 Then MsgBox ("sheet1 がありません") End End If Worksheets("sheet1").OnSheetDeactivate = "Menu_Enabled_True" End Sub Sub Only_Sheet1_Reset() Worksheets("sheet1").OnSheetActivate = "" Worksheets("sheet1").OnSheetDeactivate = "" Worksheets("sheet1").Select Menu_Enabled_True End Sub Sub Menu_Enabled_False() For Each mn In ActiveMenuBar.Menus mn.Enabled = False Next mn End Sub Sub Menu_Enabled_True() For Each mn In ActiveMenuBar.Menus mn.Enabled = True Next mn End Sub
Keywords: KBHOWTO KB402468
Technology: kbExcel500 kbExcelSearch kbExcelWinSearch