Posts by Craigside

Hi

I have compared exactly the Trust Centre settings for my Win10 laptop (which doesn't display this problem), and the new Win10 workshop PC, and they are the same?

I do not understand how/why this problem persists.

Thank you

Hi

I already tried this initially...

I've tried again, doesn't change anything though...

Hi

Here is screenshot before adding new code;

This is with new code added;

This is the problem message;

Thanks

Hi

I've added your code, it now looks like this;

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
lastsheet = Sh.Name
End Sub


Sub Workbook_Open()
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Application.DisplayAlerts = True
End Sub

Saved it, restarted and problem still exists...

Hi

Thank you, I think I've found it.

However I can't seem to upload/include a screenshot image...

This code is already in the location;

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
lastsheet = Sh.Name
End Sub

Yes

I tried on my workshop PC however I couldn't clearly find the module ThisWorkbook?

Thank you

Hi

Ok. On my 'main' pc (Win10 Excel '19) I manage and edit my SS. This 'master' version doesn't have problem with the popup warnings (but I do recall some time back I was advised how to stop them...).

After editing on 'main' computer I copy latest version across LAN to 2nd PC in workshop.

New PC in workshop Win10 Excel '19 - does have problem with popup messages.

I have lots of macros on main PC, I don't have problem with popups and the whole SS is transferred to the workshop PC each time.

If I edited macro on main PC (which doesn't have problem with popups) and transfer to workshop - it will overwrite everything on the workshop PC?

Thanks

Hi

My workbook has many images (photographs). Each image is linked to a pdf file relative to the image. I click the image and the pdf opens. On this new excel '19 install i'm seeing the warning pop-up message.

On my other PC running same SS and pdf's , the message is disabled - but I don't know how I did it...

I do use macros but not to open a link to a local file?

Thanks

Hi

Sorry for my ignorance but what should I do with the code?

Thanks

Hi

I've 2 PC's on LAN and I run a fairly big (90Mb) excel 2019 SS to manage my business. The SS contains many 100's of images, each image is linked to a PDF file. The image is clicked and the PDF opens to display the information. The PDF files are located locally in same folder as the SS.

My Windows10 LapTop has been running excel 2019 32bit for couple of years and I somehow resolved the irritating pop-up warning message. However, I can't recall how I did it?

Today I've replaced a PC on the LAN and installed excel 2019 (tried 32bit and 64bit) and I cannot seem to solve this problem.

Can anyone please help?

Hi thanks for reply.

For many years I've been selecting/copying and area of cells containing an image plus info (excel'07). I paste it onto a 'sales sheet' worksheet with same format but cell size sizes are smaller (I've now realised). It's always worked fine until now. I realise that until now the excel has been reducing the size of the pasted image to fit the area.

Now it isn't reducing the image size so it it twice as big and overlaps (in excel365). A real pain tbh.

Many thanks for any suggestions.

I've moved my large business SS from excel 2007 to Excel365 (to work with my new win10 laptop). My SS is to manage artworks, and has 100's of images in a worksheet along with data. What I am experiencing is;

I 'select' an area of cells that includes an image and data, I go to the worksheet I want to paste it into, select the location and 'paste'.

Usually, in excel'07 the copied cells are pasted straight in and the image automatically fits the space (the cells are smaller in the target worksheet).

However, in this excel365 I paste the contents and the image stays large, ie. it doesn't automatically shrink to fit the space?

Any help much appreciated.

Also, how do I mark my post as 'answered'?

Thanks

Thanks Roy, I didn't know how to do it...

test test test

Oh wow thank you!

Much appreciated.

I've been running my spreadsheets on excel '07 for many years. I've just moved to a new laptop with Win10 and discovered my Office2007 won't run my Excel on this Win10 laptop - it just freezes, macros won't run, etc.

So, I'm on the Win365 excel trial. This seems to be working overall, however I've now got a simple macro that won't work? The macro is to delete the contents of a column on more than 1 page.

I don't understand why it's not working. I get a runtime error '424': Object required.

When I click the debugger the line is highlighted as per;

Sub ClearLabelList2()

'

' ClearLabelList Macro // This will clear the Label List Column across multiple sheets

'

Dim Shts, ws As Excel.Worksheet

Shts = Array("Repros", "Detail List") '// Change list of sheet tab names to suit

For Each ws In Sheets

If Not IsError(Application.Match(ws.Name, Shts, 0)) Then

ws.[AE3.AE5000].ClearContents

End If

Next

End Sub

Any help much appreciated.

Hi, thank you! I apologise I think my mistake, it works fine!
Thanks again for your assistance.
Rob

Hi

Yes of course it runs but the postion of the data pasted from tables Data2/Data3/Data4 and Data5 are not in the correct position? The pasted rows do not maintain the correct row spacing so I do not have continuinity or useability in the resulting data.

Thanks.

Hi

Sorry for delay. I've tried amending your macro but it doesn't work properly? For testing I set the last rows as 42/33/33/33/33

please advise? Thanks

Hi
i am away for 3days I can’t look at it until Tuesday, no panic thank you!
Rob