Excel Disallow movement of embedded PDF


Joined
Feb 23, 2018
Messages
66
Reaction score
24
HI all

I have embedded a PDF document as an object on an Excel Spread sheet.

I want to fix that PDF object in place. I have selected 'Don't move or size with cells' in the format options but it can still be moved.

I don't want to protect the worksheet as it needs to be edited by others.

Any ideas?
 
Last edited:
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,508
Hmmm that's a good question. I think you might need to lock the cells themselves so that they can't be changed, which you can do by protecting all or part of the workbook. All cells are locked by default, so if there are any cells that need to be editable then you need to unlock them first (select them > Properties > Protection > uncheck the Locked box), then you can apply the protection to the sheet / book. This is just theoretical, I don't have time to test it myself, but it's what I would try first.
 
Ad

Advertisements

Joined
Feb 23, 2018
Messages
66
Reaction score
24
OK I have played with Protect Worksheet. To get to where I need to be, I have to Protect the worksheet and select all options except Edit Objects.

This allows everything to be edited except objects. To my mind that is a bit counter-intuitive but that's how it is!!

Thank you for the nudge in the right direction Becky!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Problem with embedded object in Word when converting to pdf 0
Word Embedded pdf file in MS Word - truncated title / caption 2
Word PDF to Word (or similar) 9
Save as PDF in Office 7
Access access pdf printer 0
Access Fillable Access PDF Reports 0
Word Word 2007 PDF query 0
Excel Open pdf from excel 2

Top