ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   avg test failed or no virus found (https://www.excelbanter.com/excel-programming/323900-avg-test-failed-no-virus-found.html)

Greg[_19_]

avg test failed or no virus found
 
When I added the code for moving the sheet it came up with this error

run-time error '-2147352565 (8002000b)':

AVG Test Failed or no virus found

Please advise

Here is the code i use

Private Sub CommandButton2_Click()
Workbooks.Open Filename:="C:\idsc\DESIGN\health care plan\BLANK
SHEETS.xls"
Sheets("PRIVATE INSURANCE").Select
Sheets("PRIVATE INSURANCE").Copy Befo=Workbooks("MALE client
database.xls"). _
Sheets(1)
Sheets("PRIVATE INSURANCE").Select
Sheets("PRIVATE INSURANCE").Move after:=Sheets(i)
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("PRIVATE INSURANCE").Select
Range("A6").Select
Selection.insert Shift:=xlDown
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=
_
"'PRIVATE INSURANCE'!A1", TextToDisplay:="'PRIVATE INSURANCE"
i = Sheets.Count
Sheets("pRIVATE INSURANCE").Move after:=Sheets(i)

greg2.Hide
greg3.Show


Thanks in advance

Greg



Greg[_19_]

avg test failed or no virus found
 
It is fine I managed to work it out I had the code repeating itself soon as
I noticed the error the message stopped


Thanks Greg




All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com