vase sheet khas injori benevis
کد:
Private Sub Worksheet_Activate()
Application.CommandBars("Ply").Enabled = False
End Sub
Private Sub Worksheet_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub
vase mohkam kari ham
in dota ro ham to thisworkbook copy kon
کد:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Ply").Enabled = True
End Sub
Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub
va ama chera bara bazia moshkel pish miomade, in bode ke onha vaghti ke hamon sheet ke right click tosh ghire fal bod hamon sheet ro dar hale entekhab az kole excel khkarej mishodan va dige in amale khonsa nemishode yejorai , harchand deactive shodan ro ke gozashtam shayad niaz nabashe .. chon test kardam vase man javab dad, deactive ro ham gozashtim ke agar 2 ta masalan file baz bod va az ye ki be yeki dige raftin ghire fal dbare adi beshe, ke dar vaghe to deactive sheet gonjonde shode va nabayad moshkeli pish biad. dar kl daste dosaye ghabli vase zahmati ke keshidan dard nakone ba ejaze ona in harfaro zadam
علاقه مندی ها (Bookmarks)