Hi
I have about 10 shapes on a worksheet. Half of them run VBA when clicked.
One of the shapes runs a VBA procedure that imports data from another workbook and populates another worksheet (in the workbook with the shapes). However, for part of the time (about 2-3 seconds) whilst the VBA is being run all the shapes disappear.
Just a few points to make:
(1) I am not using the copy PasteSpecial method. Instead I am using the following method.
Worksheets("Sheet1").Range("A1").Resize(rng.Rows.Count, rng.Columns.Count).Cells.Value = rng.Cells.Value
(2) The following settings have been applied at the start of the VBA:
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
Any help would be REALLY appreciated!
Many thanks in advance
Bill
Bookmarks