Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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
|VBA Code to edit a embed word object in an excel file||3||44|
|How to assure a MsOffice apps doesn't open up a malicious VBA hidden code||7||40|
|Highlight changing numbers in column||3||21|
|simple excel formula||4||18|