Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Preventing an object being moved around the worksheet

I have created a workbook with various embedded pdf files using icons which I
want to physically fix in position so that they cannot be dragged around the
sheet and misalingned with the text by the user. On the other hand, ther
user must be able to click on the icon and access the embedded pdf document.
Is this possible?

Mike suggested "Simply protect the sheet making sure 'allow users to edit
objects' is
un-checked.

Selecting all cells and removing the locked checkmark means users will still
be allowed to edit cells."

BUT unless I am particularly stupid (very likely!) I cannot seem to
make this solution do what I need it to. I can format all cells to be locked
and I can protect the worksheet allowing users to edit the object but this
still allows the user to drag the icon to any cell and then save the change
so that when he/she opens it up again, the icon is where he/she left it and
not where I want it to be.

What I suppose I am looking for is to associate the icon/object with a
specified cell and allow the user to open it but not to move it to another
cell.

--
paul
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Charts and Charting in Excel 3 August 24th 06 07:26 PM
CTRL Find is preventing me from navigating around my worksheet gillywilly55 Excel Discussion (Misc queries) 1 April 3rd 06 12:36 PM
Can the bottom tabs in Excel be moved vertically on a worksheet? Laura Excel Discussion (Misc queries) 2 March 9th 06 08:25 PM
Draw object pasted into Excel cannot be deleted or moved Elaine Merchant Excel Discussion (Misc queries) 0 January 7th 05 09:35 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"