Access Your Macro From Any Workbook (PERSONAL.XLSB) | Excel VBA Macro
Excel VBA Macro: Access Your Macro From Any Workbook (PERSONAL.XLSB)
💥Subscribe: / @greggowaffles
Code:
Sub worksheet_sizes_w_msgbox()
Dim temp_book As String
Dim ws As Worksheet
Dim message As String
Application.ScreenUpdating = False
temp_book = ThisWorkbook.Path & "\Temp.xls"
For Each ws In ActiveWorkbook.Worksheets
ws.Copy
ActiveWorkbook.SaveAs temp_book
ActiveWorkbook.Close savechanges:=False
message = message & ws.Name & ": " & _
FileLen(temp_book) / 1000 & " KB" & vbNewLine
Kill temp_book
Next
Application.ScreenUpdating = True
MsgBox message
End Sub
#excelmacro #excelvba
Watch video Access Your Macro From Any Workbook (PERSONAL.XLSB) | Excel VBA Macro online without registration, duration hours minute second in high quality. This video was added by user greggowaffles 15 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,49 once and liked it 2 people.