Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Now what's odd is that on Workbook_Open I have set ScreenUpdating equal to false see the below code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object) 'set zoom for active sheet to columns with data ActiveSheet.UsedRange.Resize(ActiveSheet.UsedRange.Columns.Count).Select ActiveWindow.Zoom = True: ActiveWindow.VisibleRange(1, 1).Select End Sub
I've discovered that if I add another Application.ScreenUpdating
Private Sub Workbook_Open() Application.ScreenUpdating = False Call FormatWorkbook 'activate StandardMode Sheets("StandardMode").Activate End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Cross checking component service dlls||2||43|
|Pull data from a another spreadsheet tab||3||30|
|Delete command SQLdatasource in asp.net, vb||2||20|
|Formula will not allow me to add additional rows and still function properly||5||5|
Join the community of 500,000 technology professionals and ask your questions.