اخوي مشكور بس مازالت رسايل الخطا كثيرة0
GetNo = Format(TheNo, "000000000000.00")
I = 0
Do While I < 15
If I < 12 Then
myno = Mid$(GetNo, I + 1, 3)
Else
myno = "0" + Mid$(GetNo, I + 2, 2)عند فتح النموذج
Sub hide()
Sheets("data").Cells(16, 1) = 0
Dim cb As CommandBar
Dim comd() As String
With Application
.DisplayFormulaBar = False
.DisplayStatusBar = False
For Each cb In .CommandBars
If cb.Visible = True Then
Sheets("data").Cells(16, 1) = Sheets("data").Cells(16, 1) + 1
End If
Next
End With
'''''''''''''''''''''''''''''''''''
tt = Sheets("data").Cells(16, 1)
With Application
gg = 16
For Each cb In .CommandBars
If cb.Visible = True Then
Sheets("data").Cells(gg, 4) = cb.Name
gg = gg + 1
End If عند الخروج من البرنامج